subform link not working

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

I have a form [FormIdInfo] that is used to display
information about an employee. The form contains 2
subforms. The main form displays the PIN (master field)
and the employee's first and last name. This form is
based off the table [tblpersonalinfo]. Subform1 displays
additional details about the employee and is based off a
table {tblhistoryinfo]. Subform2 displays Id information
and is based off the table [tblidinfo]. Both subforms are
linked to the master field of PIN.

I have another form [FormHelpDesk] that is used to track
helpdesk calls logged for each employee. PIN is also the
master field on this form. I used the Command Button
wizard to create a button that will open the Id form
[FormIdInfo] so that the user can view Id information
while adding a new helpdesk ticket.

The problem I'm having is that when you view the form
[FormIdInfo] by using the button rom [FormHelpDesk] the
linke to the second subform [subform2] does not work!
Subform1 works fine. To get around this problem, I
created a "Refresh" button (also by using the Command
Button wizard) so that the Id information can be displayed.

Any ideas why the link to the second subform does not
work? Sorry for the lengthy messag and thanks in advance
for your help.

Grace
 
-----Original Message-----
I have a form [FormIdInfo] that is used to display
information about an employee. The form contains 2
subforms. The main form displays the PIN (master field)
and the employee's first and last name. This form is
based off the table [tblpersonalinfo]. Subform1 displays
additional details about the employee and is based off a
table {tblhistoryinfo]. Subform2 displays Id information
and is based off the table [tblidinfo]. Both subforms are
linked to the master field of PIN.

I have another form [FormHelpDesk] that is used to track
helpdesk calls logged for each employee. PIN is also the
master field on this form. I used the Command Button
wizard to create a button that will open the Id form
[FormIdInfo] so that the user can view Id information
while adding a new helpdesk ticket.

The problem I'm having is that when you view the form
[FormIdInfo] by using the button rom [FormHelpDesk] the
linke to the second subform [subform2] does not work!
Subform1 works fine. To get around this problem, I
created a "Refresh" button (also by using the Command
Button wizard) so that the Id information can be displayed.

Any ideas why the link to the second subform does not
work? Sorry for the lengthy messag and thanks in advance
for your help.

Grace

.
I can't tell you why the second subform does not work.
Click to expand...
I would think that it should. However, I had the same
problem and solved it by making the third form a subform
of the first subform. Doing this I now have all three
forms showing the correct data.
 
Back
Top