I have a combo box that looks up a value (date) using a query in the control source. The query returns only one record which I wish to use as the default record that is written to the table allowing the user to override with a different date if needed. The combo box is obviously bound to a field in a table.
I have tried all of the following in the default value property of the combo box. None work.
This should not be difficult but all research turns up the same answers as above. Help?