|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 4th, 2009, 02:22 AM
posted to microsoft.public.access.forms
|
|||
|
|||
pull down
Hi,
I have the pull down so that the user must select what's available, but how can I force a user not to leave a pull down blank. I've tried Default Value but it doesn't work. Thanks, Joel 
|
|
#2
December 4th, 2009, 03:03 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
pull down
On Thu, 3 Dec 2009 18:22:02 -0800, "Joel Allen"
wrote: Hi, I have the pull down so that the user must select what's available, but how can I force a user not to leave a pull down blank. I've tried Default Value but it doesn't work. Thanks, Joel What's the context? Is the Combo Box (the real name of the control) bound to a table field that you're updating, or an unbound control to select a record for editing and viewing, or what? -- John W. Vinson [MVP]
|
|
#3
December 4th, 2009, 03:15 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
pull down
Use the Before Update event of the form to set focus back to the combo box.
You can also add a validation rule to both the table and the form, which the user won't be able to ignore. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Joel Allen" wrote in message ... Hi, I have the pull down so that the user must select what's available, but how can I force a user not to leave a pull down blank. I've tried Default Value but it doesn't work. Thanks, Joel
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
