Required Field in Subform

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

Guest

I understand how to make something a required field at the table level, but
I'm not sure I should do it in this case.

I have a form (this is the only way people will be entering data). The main
form is the employee's information and then I have about 15 tabbed subforms
that contain the employee's access to different applications, reports,
systems, etc. I want to make the date that the system access was granted
required so that someone won't just choose the type of system access and
forget to put in the date.

I'm concerned about how to do this, however. I don't want to make that
subform required (an employee may or may not have access to that particular
system) I only want to make the date required IF any other information is
entered into that subform record.

I hope that makes sense.

Thank you - any help is appreciated.
 
Hi.

Is the subform in question bound to a single table? If so, you should be
able to set the Required property for that particular field to Yes. That
way, whenever a new record for that table is entered via the subform, that
field will be required.

-Michael
 
You could also make it automatic so that when the user begins entering data
in a tab the date is stored in the record:
Put Me.tblOneDate = Now() in the AfterUpdate property.
 
I understand what you're saying and I may use that for other things! :-)
However, it would likely be the situation that this information was not
actually inputted on the day that the access is granted because the employee
has to fill out a form and it goes through stages and then comes to me a
couple weeks later. But thank you for your reply.
 
The subform is bound to a single table although the table itself is bound to
more than one table (because of lookup fields.....which I didn't know the
EVILS of until I started coming here...now kicking myself because I have
about 20 of them in my database!!!).

I will give it a try - I guess I could test it out to see what happens. If
it doesn't work I will write back here.

Do you suggest that I make it a required field at the table level or the
form level...or does it matter?

Thank you.
 
I misunderstood. I thought system access was access to the current db. I
see now that it is some other system.

Tanya said:
I understand what you're saying and I may use that for other things! :-)
However, it would likely be the situation that this information was not
actually inputted on the day that the access is granted because the employee
has to fill out a form and it goes through stages and then comes to me a
couple weeks later. But thank you for your reply.
You could also make it automatic so that when the user begins entering data
in a tab the date is stored in the record:
Click to expand...
[quoted text clipped - 18 lines]
Click to expand...
 
Back
Top