Display date in Combo?

[geralf]

Hi,

I'm trying to get an unbound combobox in a form to show what I want. I'm using this combo to change the forms recordsource, so only entries from the selected date shows. This works fine. If I add a new record to the form with the current date, I would like the combo also to be displaying the current date. The combos recordsource is a query based on the entered dates. So the date is in the combos list. So how can I, using VBA, 'select' the date as I would from the dropdown list?

TIA

 

[Rich]

Save the record and then Requery the combo box

 

[geralf]

Thanks for your reply Rich!

I haven't made myself clear enough. Sorry about that.

The new date is already in the combos list (using a requery as you posted). It isn't displayed in the Combos Control Box. It is blank (unbound combo) I would like to see the date here.

TIA