Going to a B form and back to A form

[HappyRed]

I have a very simple question, I guess.

I start with Form A. On it I have a combo box that allows me to select a Vendor ID among many, once selected I open a new form that displays all Purchase Orders for the selected Vendor. This Datasheet view allows me to choose a specific Purchase order which I can display in Form A. So I go back and display it. Everything works bunderbar.

However I have 3 Combo boxes, the other 2 allow me to search by PO number and by Job number.

After I return from Form B these 2 Combo boxes no longer work. They do if I don't go to Form B.

How can I go to Form B and come back and keep the funtionality of Form A?

Anybody knows what I am talking about?

I will appreciate the help.

Red

 

[willir]

To answer that the question, we need to know the RowSource. The row source will dictate what the conbo box displays.

A common remedy for the RowSource is to requery the RowSource. Note that you can change the source for the RowSource.

Another common remedy is to use Refresh.

Perhaps you can use the GotFocus event to refresh or requery the combo box.

 

[HappyRed]

I'll try that. I thought so but I was not sure.

I did and it didn't help.

The row source it's a query.