Access form/ VBA

I need to have my access form automatically populate certain fields when criteria is met. Example; If acount number = 100 then Fname = ron Lname = ferris ID = 45 etc.... I don't want to hard code the control or the form, unless this is the only way. I want the form to analyze the asociated table and verify if the criteria is being met then fill in the fields with the correct data. If someone can show me the way I would appreciate it, my project is due tomorrow. Any additional info can be given by e-mail. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. ## Platform Win ME