requery

[raffi]

Hello, i have an item table, and a customer table, and a conjunction table with has both CustomerID and ItemID and a Primary key which has an autonumber




i created a form out of the conjunction table, and within the form i placed 2 combo-boxes

first combo-box is the customer lookup list
second combo-box is the item lookup list

and within the same form, ( the conjunction table form ) i also have 2 buttons,

the first button is for the Item Main form, which when clicked upon it opens the form in dialog view, so i can manage the items much like adding deleting etc..
the second button is for the customer Main Form ( again in dialog view ) , to manage the customers adding deleting etc...

now .. the question is ... when i open the customer or item dialog view form, within the conjunction table form, and add a new customer or an item, and close the customer or item dialog view form, how can i requery the customer or item combo-box, after closing the dialog view forms,

i try'ed using on close event procedure and wrote, requery combo-box's and so far it hasn't,

any help would be much appreciated.

[amrut]

Can you post your code in the Close Event?

[John_G]

In the code that opens the forms for Item or Customer, open the forms using acdialog as the data mode parameter (5th parameter):

DoCmd.OpenForm formname, , , , acDialog. You have to use it this way - specifying the form as dialog doesn't work.

This will stop the code until the form is closed.

Then after the Docmd.OpenForm..., requery the related combo box: Me!comboboxname.requery.