Default Value in a combo box on a form

  • Thread starter Thread starter richard
  • Start date Start date
R

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
 
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.
 
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/
 
Back
Top