When changing records not requerying 1

[frantik]

Hi

I have a form holding a few subforms.

On one of these subforms is a drop down box which is populated via a query - its contents are dependant on - for that particular record.

When I browse through the records - the query is not updating - so the drop down box gives me the same choices as for the first time it was refreshed - i.e. by updating a field.

What I want is to be able to refresh that combo box every time I change record

Can anyone tell me how to do this please?

Thanks

 

[PHV]

Requery the combo in the Current event procedure of the form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886