Using Subforms

  • Thread starter Thread starter Josef
  • Start date Start date
J

Josef

I have an Employee database. Once i select an employee, i click a button
to display the employee sick days, hosted on a different table.

my problem is that when i open a new form/subform for an employee that
does not have any outstanding sick days, it causes errors. somehow the
form/subforms are not linking up for me. any suggestions??
 
I have an Employee database. Once i select an employee, i click a button
to display the employee sick days, hosted on a different table.

my problem is that when i open a new form/subform for an employee that
does not have any outstanding sick days, it causes errors. somehow the
form/subforms are not linking up for me. any suggestions??
Click to expand...

Well, this isn't really a Subform. Would it be possible to have the
second form actually in a Subform control, on the employee form, using
the EmployeeID as the master/child link field? This would save some
code (you would not need the button at all), avoid the no-records
problem (the subform would simply be blank, ready to accept a new
record), and probably be simpler for the user.
 
Back
Top