Combo Box Text Validation

[psyam]

Hi Evry 1,

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?

Thanx for ur time,
Syam.

 

[smedvid]

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"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[psyam]

Thanks...Thats working...

 

[wetbrainfart617]

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.

 

[smedvid]

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"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[genaccess]

After update event of combobox
use Select Case Me.Name of the combobox

Case "OptionA"
Do Noting

Case "OptionB"
Msgbox "Remember to notate...."

End Select

You can also use IF statement