put query result to cbo control on the form

[Song Su]

I have a query as follows:

SELECT TOP 1 qryVisitData.timeIn
FROM qryVisitData
ORDER BY qryVisitData.timeIn DESC;

I want to assign the query result to my cboTO control on my form so when I
open the form, I already have the default date. How to do it? Thanks.

 

[Michel Walsh]

Type that SQL statement in the Row Source property of the combobox. Do not
use quotes to delimit what you input, in design view of the form, the
property RowSource knows it is a string you are supplying. Also, be sure the
Row Source Type is set to Table/Query (which is so, by default).

Hoping it may help,
Vanderghast, Access MVP

 

[Douglas J. Steele]

Why bother using a combo box if you're only going to allow a single choice?

Try an unbound text box with a control source of

=DMax("TimeIn", "qryVisitData")

 

[Song Su]

Thanks, Doublas. It works great! I use combo box because the drop down
button will activate a calendar control so user can pick a different date.