retrieve all records but go to a specific record

[gymphil]

I would like to return all records from a query but go to a specific record
that would be entered in to a combo box on a form. Can anyone assist me
please?

 

[gymphil]

Michel,

Thank you for the response, unfortunately I have no idea how to apply this,
can you give me some idea where to start, is there any code that you can
suggest I try?

Thanks

 

[Michel Walsh]

Have you tried the combo box wizard (for within a form design)? Have a form
bound to a recordset, then with the control's wizard active, add a combo
box. There you should have the third option available to you, once the
wizard started, as shown in the supplied picture in my previous message,
which will generate the code for you.



Vanderghast, Access MVP