If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Subforms
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?? |
#2
|
|||
|
|||
Using Subforms
On Mon, 31 May 2004 12:19:13 +1000, Josef
wrote: 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. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|