Refresh a form

[johne417]

Simple question from a newbie, please help. I have a form, called frmEditCarriers. The recordsource of this form is a an extremely simple query, Select Name, Address, ID from Carriers. This gives me 500 records (the number in the Carriers table obviously). I start on record 1 and I don't want my users to have to scroll through hundreds of records to get to the one they want. I have a dropdown box on this form called Combo1, which has the source 'Select Name from Carriers'. I'd like the OnChange event for this dropdown to go to the record within the form that contains the information for that carrier. Probably extremely simple VBA code. How do you do this? Thanks in advance,
~John

 

[PHV]

Either follow the wizard or read the FAQ area in this forum, as an entire section is devoted to combo.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244