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.

Try setting the combo's Default Value.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ggerke" <(E-Mail Removed)> wrote in message
news:AEF4F696-F377-4095-AEB2-(E-Mail Removed)...
> 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" wrote:

> Try setting the combo's Default Value.
>
> Something like this:
> =[Combo1].ItemData(0)
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "ggerke" <(E-Mail Removed)> wrote in message
> news:AEF4F696-F377-4095-AEB2-(E-Mail Removed)...
> > 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.
>
> Thank-you very much