I using a form for user to enter data for a new record and i have a combobox on it .How to restrict user not to enter anything except to select from the options I have?
If I understand correctly, you wish to limit the combo box selection to the Select Statement used within the Combo-box. There is a property called Limit-to-List within the combo-box. Select this option and set to True/Yes? htwh,
Steve Medvid
"IT Consultant & Web Master"
Can you guys help with this one? I'm new to Access and I bet this is something very simple.
I have a similar situation: I have a form with a combo box with "OptionA" and "OptionB." If "OptionB" is selected, I want Access to pop a warning message with custom text, "Remeber to notate this entry." I set a data validation rule and I got the message to "pop" correctly, but Access won't allow the user to continue unless "OptionA" is selected.
I want "OptionB" to remain in the combo box but allow the user to click "ok" on the message and move on to the rest of the fields in the form, I thought I reach out for help.
Thank you all so much!
Howard
I'm sure it's something simple, but I'm such a "newbie" to Access and this forum.
Perhaps OnChange Event? On the OnChange of the combo B is selected, simply have a msgbox in the OnChange Event. Then Setfocus to the combo A
In terms of checking if a value is set before continuing? One approach is to have a check on the OnChange Event of every control to insure that a value is selected. Or BeforeSave? many options here...
htwh,
Steve Medvid
"IT Consultant & Web Master"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.