database and combo vboxes

[JOE POLLOCK]

I have a multi-table db. One is for customers and another, for the sake of
argument is for orders. THere is a form for customer maintenance and another
for order entry. I can enter in a new customer into the customer form and
then click to open the order form and the customers name and information
would be available in the combo box. This was the case until yesterday. I am
not sure what is going on. Any ideas on a fix?

 

[John W. Vinson]

I have a multi-table db. One is for customers and another, for the sake of
argument is for orders. THere is a form for customer maintenance and another
for order entry. I can enter in a new customer into the customer form and
then click to open the order form and the customers name and information
would be available in the combo box. This was the case until yesterday. I am
not sure what is going on. Any ideas on a fix?

If the orders form is open while you're doing the customer data entry, you
will need to Requery the combo box in the AfterUpdate event of the customer
form. Closing and opening the form will do the same thing (but is of course
inconvenient!)