Refreshing a forms search list

[jkoca]

I have a form which has a combo box in the header used to search existing
records and the bound fields in the body. When the form is loaded, the combo
box row source is an embedded SQL statement selecting the id and description
ordered by description.

My problem is when I change values in existing records or I insert new
records in the table, the contents of the search combo box remains as it was
when the form loaded.

My questions are:

1. How do I get this to refresh with new values ?
2. What event do I need to tie this code to ?

Thanks,

Jim Koca

 

[Marshall Barton]

I have a form which has a combo box in the header used to search existing
records and the bound fields in the body. When the form is loaded, the combo
box row source is an embedded SQL statement selecting the id and description
ordered by description.

My problem is when I change values in existing records or I insert new
records in the table, the contents of the search combo box remains as it was
when the form loaded.

My questions are:

1. How do I get this to refresh with new values ?
2. What event do I need to tie this code to ?

Use Me.comboboxname.Requery

in the ***form's*** AfterUpdate event procedure.