Competent Performer
Windows XP 
Access 2007
I'm sure I've done it before, but can't seem to find where I did it. I have a combobox on a form that is populated by a table/query. I would like the combobox to display "Select..." when the form is opened and have a message box appear if a selection is not made, meaning that "Select..." is not a real choice.
VIP
Windows 7 64bit Access 2010 32bit
Use a UNION sql to create the "Select ..." line item. Then use code behind form BeforeUpdate event to validate the combobox entry.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Impossible to select any value from the ComboBox
ComboBox, select null?
Use combobox to select form to open
Posting Permissions
Reply With Quote