Refresh Query

[Colin Hammond]

I have a list of boats and a list of moorings. I have a query that finds
vacant moorings and a combo box on my boat details form that displays this
list and allocates a boat to the mooring. My problem is that when I go to
another boat form the allocated mooring is shown as still vacant unless I
close and re-open the form.

Colin

 

[Guest]

whenever you go to a new boat (on the "on current" event) use the code

Me!ComboBoxName.Requery

that ought to do it. Although I would have generally expected this to happen
when you change the form record anyway....
--

 

[google]

You could use the F9-key on your keyboard to refresh one record.....
Shift+F9 will refresh the whole recordset.