POPULATE BUT DON'T AUTOFILL - HELP!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an event on a form. It allows the user to select an order by order
number. This combo box is tied to a query that lists all orders by order
number.

When the user selects the order number from the combo box a procedure in
afterupdate updates the form with the information for the customer.

The problem is that this also makes a whole new record for some reason. How
do you get the form to populate it's fields based on the selection without
making a new record? I want to simply pull up the existing, matching record
and modify it.

Thanks
 
Bryan

The easiest thing to do at this point is remove the combobox, and use the
wizard on the toolbox when you add the combobox back on to your form. (The
recordsource of your form will need to be a table or query whose fields are
displayed on your form).

One of the options at the beginning of the wizard is "Find a record on my
form based on the value I selected in my combobox" ... choose that option
and then continue on with the creation of your combobox.

HTH

Debra
 
Thank you Debra, it works!

Debra Farnham said:
Bryan

The easiest thing to do at this point is remove the combobox, and use the
wizard on the toolbox when you add the combobox back on to your form. (The
recordsource of your form will need to be a table or query whose fields are
displayed on your form).

One of the options at the beginning of the wizard is "Find a record on my
form based on the value I selected in my combobox" ... choose that option
and then continue on with the creation of your combobox.

HTH

Debra
Click to expand...
 
Back
Top