 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008Default Value in a combo box on a form
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.  SignatureWayne Manchester, England. > Hi > [quoted text clipped - 8 lines] > > Richard 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? SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > Hi > [quoted text clipped - 8 lines] > > Richard |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.