Default Value in a combo box on a form


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
 
Ad

Advertisements

W

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.
 
Ad

Advertisements

J

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/
 

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

Combo box default 7
A-Z Sorting Combo 2
Update combo box 2
combo box filter 1
Combo Box Help 7
Combo box questions 2
Combo Box QUESTION 5
Blank combo or list box 1

Top