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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

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.
 
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'.
 
Back
Top