Requery Combo Box Automatically From A Query

[EllaBourke]

Hi I have a table called tblBooking. One of the fields in the table is the return date of the van. I have created a query that's called qryAvailableVans. Within this I have the fields VanID, registration and return date. For the return date their is the criteria <Date() and ive unchecked the show box. This means that all the vans that have been returned before todays date show in the query. I then have a form called frmBooking. Within this, there is a combo box with the row source qryAvailableVans. This therefore only shows the details of the vans that are available to book. Is there any way to automatically refresh the combo box options because I have to close the form and then reopen it if I change a return date in the booking table or process a new booking.

[Seth Schrock]

What I would do would be to put the following code in the control that you would edit just before your van combobox After_Update event:

Me.ComboBox_Name.Requery

This is update the list just a second before you use it.