Updating a Combo Box

[Alan R]

Hi,

Can anybody help me please, i suspect that this problem has a simple answer but a search on the forum didn't really answer it.

I have developed a Database for my brother who runs his own business. Within this database he has a number of Tables including one for maintaining / recording his clients details i.e. Company Name, Point of Contact, Telephone number etc etc. and all this information is recorded via a form.

Part of this database is to produce and record details of estimates, invoices, VAT charges etc. In order to generate a new Invoice or Estimate, i have created another form which has a Combo box on it linked to the Customers Table to allow the invoice or estimate to be created for that customer - still with me?

My problem is this - if i add a new customer, their details do not appear in the combo box on the create invoice / estimate form unless i close the database and then restart it. How do i make the combo box include the new customer details without having to close / reopen the database?

I have played around with requery but with no joy. The database works fine but this last simple(?) problem is bugging me.

Any help / advice greatly welcome and appreciated.

Alan

 

[Alan R]

Typical - no sooner did i post the question then i get the Combo Box to update using a solution i am sure i had already tried!!

I now however have another problem with this, when i select the new customer from the combo box, some of the information on the form should change to this customers details accordingly, however in my case nothing happens. None of the details are updated / changed.

Can you tell me what i need to do to get this to work please?

Many Thanks

Alan

 

[nikkypickles]

This might be a really stupid suggestion but have you tried using Me.Refresh on the OnClick (or AfterUpdate - I forget the right one) event on the combobox?

 

[Alan R]

Nilly

Thanks for your reply but i had cracked it.

Busy making a cup of coffee and had a brainwave / flash of inspiration / rush of whatever to brain (still hurting now)!

Put Me.Requery in the On Activate Form property.

I am failrly new to Access but having seen how simple it was and how long it has taken to correct........

Got there in the end.

Alan