Combo box in Access

[cfriedberg2]

I have created a combo box on a form. When the user selects his choice, I want the record pointer to be at that record for all the other information on the form.

How do I do it?

I used a recordset.FindNext, etc. but that presented some unexpected problems.

 

[ssatech]

Try using the combobox wizard....

 

[cfriedberg2]

I did use the wizard. That still does not give me the functionality I want. One of the things the user can do is to add a value to form through the combo box. I have that working pretty well.

However, using recordset.FindNext causes some of the records to be modified in inappropriate ways. I do not want the modification while just selecting the record, but I do want to see the correct values for each field in the record.

 

[PHV]

causes some of the records to be modified in inappropriate ways
Don't use a bound combo as a navigation tool ...

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