Make a Combo box update all other fields on form

[gxd135]

I have a form that has a combo box with names of jobs that we do. When I select a job from the drop down I want all other fields on the form to go to that record. I don't want to use the drop down as a way to select a name for a new record but I want to use it to go to old records to be updated. Any ideas are greatly appreciated..
Thanks

 

[SgtJarrow]

Add a new combobox yo your form from the toolbox, and make sure the wizard box is depressed before you add the combobox. The third option on the first screen of the wizard is for finding a record on my form....that's what you want. -----------------------------------------
Only two things are infinite, the
universe and human stupidity, and
I'm not sure about the former.
(Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: mstrmage@tampabay.rr.com

 

[gxd135]

Thank you that works great. The only other thing is I would like to enter the new data in that same field. Can I do that??

 

[gxd135]

Never mind, I got it working perfectly. THANKS A LOT