Drop down list in combo box--require choice to be made

S

smags

How do I make a drop down list of a combo box that has a bunch of choices a
REQUIREMENT for someone to fill in on a FORM? Meaning, when someone is
filling out a FORM and goes to a field that has a drop down list, how can I
make it so that they CANNOT move on to the next field until they choose one
of the options in the drop down list?
 
R

Rick Brandt

smags said:
How do I make a drop down list of a combo box that has a bunch of
choices a REQUIREMENT for someone to fill in on a FORM? Meaning,
when someone is filling out a FORM and goes to a field that has a
drop down list, how can I make it so that they CANNOT move on to the
next field until they choose one of the options in the drop down list?

Making it a required field at the table level is the surest way. One
problem is they won't get an error until the form tries to save the record.
 
J

JackP

you've got two ways of doing it :

1) default a value in; and after_update check to see if the value is null -
if it is, set it back to the default value.

this works, but isn't a very elegant way.

2) if it's a form based on a table, go into design view on the table and set
the required property of the field the combo box updates to 'true'.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top