Default Value in a combo box on a form

[richard]

Hi

I have an unbound combo box on a form in which I would like to show a
default value which I want to be the first client name alphabetically in the
field ClientName in the table tblClients. This is also the Row Source for the
combo box
I am thinking this should be done using the Default Value in the combo box
properties but don't know how it should be done.

Any help please

Richard

 

[Wayne-I-M]

Best think would be to create a query based on your tblClients. You can sort
this how you want. Base the combo on this

If you open the form in design then open the properties box of the combo.
Click the build option (...) on the source and the wizard will create the
combo base query for you.

 

[Jeff Boyce]

Richard

Just checking to be sure what you have is what you want...

An unbound control (your combobox) can display values (e.g., a client name),
but it will NOT store that value in any table (because it is unbound).

Is there a reason you want a form to open up displaying a client name but
not to save it?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/