Field validation on a form

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

Guest

Hi I have a db being used as a booking diary, the problem I have is as follows;

there are fields for current date, time slot, and 3 supplier fields. What I
want to do is when a time slot is selected (from a drop down combo box), for
the current date check to see is any one of the supplier fields is empty, if
it is, then that field can be used, if all are full then do not allow that
time slot to be used.

the form will be on a network share and be used by multi-users
 

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

Back
Top