Requery listing after new record

[CraigBFG]

I'm looking to requery a Company listing after entering a new record, but am have difficulty.

From my CompanyListing form, I click on NewCompany which takes me to a blank form to complete. On saving the form, it closes and takes me back to the listing. However, the new company is not shown.

Can anyone help.

 

[Mile-O]

You could have a read of either of these FAQs first:

• [FAQ] Adding New Entries to Table From a Combobox (DAO)
• [FAQ] Adding New Entries to Table From a Combobox (ADO)

Is this the sort of thing you are trying to do, but with a data entry form to pop up rather than a message box?