combo box as record selector

[ChrisDo11]

i have a form based on records in a table. in the form i can use to record selectors to navigate through all the records and update which ever feilds i want. All the records have a unigue reference number. is there anyway i can make the reference number field in my form a combo box, so that when i select a different record from the combo box the rest of the form goes to that record also?

basically, if i have 15 records, i don't want to have to click the "next" record selector 15 times to get to that record. i can just select it from the combo box.

i can make the combo box, and it will display the right information for that record, only it won't let me edit the information, it displays it only.

thanks for any help.

 

[Dugantrain]

If I'm understanding your problem correctly, use the combo box wizard. Select the third option "Find a record on this form based...". That will then display the appropriate record based on what you select (I should note that this particular type of combo box works best when the Control Source that it's based from has unique values, such as an Autonumber field).

 

[ChrisDo11]

i don't seem to have the 3rd option ??

 

[KevinM]

For some reason you don't get the 'third option' if you used the form wizard to create your form, or more accuratley if your form's recordsource is based on selected fields rather than the table/query itself.

Copy the 'select....' recordsource to the clipboard.

Select the actual table/query from the dropdownlist in the recordsource property.

Use the combo wizard and you should see the 'third option'.

Paste the recordsource back into the form's recordsource property.