Skipping field

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

Guest

I have a form that has yes/no fields and a date associated with this yes/no
field. I only want the user to have to put in the date, if the yes/no field
is yes. How would I 'skip over' the date fields if the value of the other
field is no?

Thanks,
RandyM
 
Why don't you get rid of the yes/no field. It sounds redundant. If a date
is entered, then you know the situation exists. If the date is blank, then
you know the situation does not exist.

Your example is like having a "Terminated Y/N" field and a "Terminated Date"
field in the table. You simply don't need both. They are redundant.
 
I have a form that has yes/no fields and a date associated with this yes/no
field. I only want the user to have to put in the date, if the yes/no field
is yes. How would I 'skip over' the date fields if the value of the other
field is no?

Thanks,
RandyM
Click to expand...

If you have repeating pairs of yes/no and date fields in your table,
I'd really suggest that you redesign your table structure: it sounds
like you have a one to many relationship embedded within each record.
A second table with a text field containing what you're now using as
the fieldname (event type??) and a date/time field would be much
better.

John W. Vinson[MVP]
 
Rick,
Thanks for answering and you're right...it does sound redundant,
especially when you explain it like that. I'll definitely look into changing
it. I appreciate yours and everyone else's patience with newbies, which I
definitely consider myself.

Thanks again,
Randy M
 
John,
Thanks John, I appreciate the advice. I'm going to look into yours and
Rick's suggestions. And, thanks for your time and your patience with us
newbies.

Thanks again,
RandyM
 
Back
Top