Setting the Deault value of a combo box

G

Guest

Hi, I'd like to set the default value of a combo box to the first value in a
result set returned by a select query.

[myQuery]![Field]! ???? =)

Could someone help me out here?

cheers
 
A

Allen Browne

Try setting the combo's DefaultValue to:
=[MyCombo].[ItemData](0)

If the combo has Column Headings, use 1 instead of zero.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem changing the rowsource of a List Box filtered by combo box 3
auto populate text box based on combo box value 1
Unable to select a value from combo box 3
Combo Box Lookup Value 4
Combo box display 3
Default value to unbound combo box 1
Combo Box default value 1
can't select from combo box 4

Top