Combo Box Requery

[Mahatmt]

I have a form with a combo box to retrieve a list of customers but the form also has a button that calls the New Customer form. I can go to the new Customer form and enter a new record. i then issue a combobox.requery command, but the box is not required (until I oerform a cancel on the current Order record that I have).

Any suggestions. Could it be possible I still have the Customer table open????

Thanks.

Mike

 

[scking]

You should not perform a requery on the combo box unless you need it since you could requery it x times before you even need it. You could refresh it in the GotFocus event if you wish. That way it would only refresh one time. Or even in the form GotFocus event.

I am a little hazy on exactly what you are trying to say. Does something fail?

-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------

 

[Darrylles]

Hi Ma,

Are you updating the new record before performing the combo requery?

i.e. You need to move to another record, or save the record - then perform the combo requery.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk