combo box query

[Mute]

HI,

I hav a customer form which allows me to view details of all the customers in the database.

A combo box is used to select the customer's name which den brings up the details of the customer.

If i wanted to edit any of the details i wud click on a button which wud open up another form with the details of the customer in an editable form.

Upon closing this form after making changes i am taken bk to the 1st form (view customer details) and i find the details hav all changed except the customer name (in the combo box).

This only changes after i press refresh and den click on the combo box and then select a different customer.

Is der a way to allow the change to be seen instantly like all the other details?

Thanx in advance to any1 who helps.

 

[maxmangion]

try putting me.requery on the OnActivate event of your form.

 

[Mute]

Thanx for ur reply,

Im sorry but im kinda new to Access so need a bit more help plz.

The form to view the customer's details is called: View Supplier Info
the form to edit the customer's details is called: Edit Supplier Info

On either form i cant find OnActivate on the form properties and wud i have to enter me.requery as it is?

 

[maxmangion]

go to the design view of your form, then at the top click on the View menu and select properties ... a window should open up, locate OnActivate, click on it and click on ... then choose Code builder. Once there type Me.Requery.

 

[Mute]

It made no difference, hope i did it right.

I changed the properties in the view customer form.

The name does change but only when i click on the arrow

It looks like dis:

Lets take Mute as the customer,

MUTE \/

If i den edit dat to "mute" it wud look like dis:

MUTE \/
Blah blah
Mr No name
mute

it wud change in d list but it wont change as it is - i wud hav to selct the changed name from the list.