Using Subforms

[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??

 

[John Vinson]

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??

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.