Updating information in a combo box

[NJBuckeye]

I have the following"

Tables: Contacts, Organizations

Query: qryOrganizations (sorts alphabetically and includes only name and ID)

Forms: Contacts, Organizations

I started with the Microsoft Contacts template from their website, but it assumes one person per orgnaization.

So, I added the organizations table. In this table, the name is added, address, etc., and an ID number is assigned via autonumber.

In the contacts table I added an OrganizationID field.

From the Contacts form, I added a button, "New Organization," which opens the form Organization, where I can add name, address, etc. I have a close form button, which then leaves me with the contacts form.

In the contacts form, I have a combo box (organizationIDcombo) to pick the organization name... it is actually the ID that is stored.

But, it doesn't show the newly added organization.

I've tried requery comands on got focus, which didn't work, but macros aren't my strong suit. Never had anyone to show me nor have I found a book that starts from stratch. Macros always seem to be a REALLY small chapter at the back of a book... like SQL or VBA.

So, how can I get the combo box to show the newly added organization?

Thanks!

 

[rainman89]

in the close button of your other form put

forms!formnamewithcombo!comboname.requery

changing the form name and comboname of course

 

[NJBuckeye]

OK... but I got a message that the macro or macro group doesn't exist.

 

[NJBuckeye]

But... it works... so how do I get rid of the error message?

 

[rick roberts]

ive looked all over for a solution to this problem -- requery here - refresh there -- thanks for finally offering us a solution that works - -for me at any rate