Using Combobox to navigate form

[Bill S]

I have a form (customers) with 2 subforms (orders and payments). The form
data(customer data) cannot be added/edited/deleted. The 2 subforms are used
to add new order and payment data. Both the form and subforms are in the
Detail section of the form.

I have over 400 customers and would like to use a combobox to select the
current customer, instead of using the navigation buttons. I am having
trouble setting this up.

Is this possible?

Thanks,

Bill

 

[Arvin Meyer MVP]

Create an unbound combo box with the wizard and choose the last choice: Find
a record ...

 

[Bill S]

Thanks. It worked perfectly.

Create an unbound combo box with the wizard and choose the last choice: Find
a record ...
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com