Display record in a combo box

  • Thread starter Thread starter ggerke
  • Start date Start date
G

ggerke

Hello all,
I have an unbound combo box which I use to lookup records from a table, call
it [fieldID]. I would like to display the first record as the default in the
combo box so it doesn't show as blank when the form is opened. Is there a way
to show the first record in the table without binding the combo box?
Additionally, can I use an IF Then to show a specific record if it exists,
(eg IF fieldID = "ABC" THEN [cbo lookup].defaultvalue="ABC")???
Your help is much appreciated.
 
Allen Browne said:
Try setting the combo's Default Value.

Something like this:
=[Combo1].ItemData(0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

ggerke said:
Hello all,
I have an unbound combo box which I use to lookup records from a table,
call
it [fieldID]. I would like to display the first record as the default in
the
combo box so it doesn't show as blank when the form is opened. Is there a
way
to show the first record in the table without binding the combo box?
Additionally, can I use an IF Then to show a specific record if it exists,
(eg IF fieldID = "ABC" THEN [cbo lookup].defaultvalue="ABC")???
Your help is much appreciated.
Click to expand...

Thank-you very much
Click to expand...
 
Back
Top