Help with form/subform problem

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a table, tblindividual, which holds names and addresses of officers.
The primary key is ID. Each year they have to complete a registration form
and return it to us in order that we can then send out a new registration
card. So I have a table tblIDCards with Primary key CardID, and these fields
ID, txtidform (date field) and txtidcardissued (also a date field) I have
two problems to keep an annual record.
1. I have a form called frmMain (this is a menu form) with a subform,
frmRegistration, which is based on a query which includes tblIndividual and
on this form is a tabcontrol called TabCtl44. On one of the tabs I have
another sub form frmidcards based on tblIDCards which is linked to the
frmRegistration by the primary key ID from tblIndividual and the field ID
from tblIDCards (the foreign key???). I have a control on frmRegistration
called IName (a calculated control whose control source is =[txtfirstname] &
" " & [txtsurname]) and I have a control on the subform frmidcards called
IName2 whose control source should reference IName with this as the control
source.
=Forms!frmMain!Subform1!frmRegistration!IName.
The subform frmidcards is in datasheet format so that we can enter the
relevant dates each year and view the history.
However I get the dreaded #Name? so my control source must be incorrect. Can
anyone tell me where I've gone wrong with that problem.

2. When I try to enter data in the subform frmidcards I get an error message
that says
The LinkMasterFields property setting has produced this error: 'The object
doesn't contain the Automation object 'tblindividual."
What does this mean?

Hope I've explained my problems. Any help would be appreciated.
Tony
 
Hi solved the reference problem (incorrect form name in control source and I
stared at that for hours!!!!!!!) in 1 but still have problem 2
 
Back
Top