Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / December 2007

Tip: Looking for answers? Try searching our database.

Help with form/subform problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tony Williams - 13 Dec 2007 11:14 GMT
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
Tony Williams - 13 Dec 2007 12:22 GMT
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
>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
[quoted text clipped - 26 lines]
> Hope I've explained my problems. Any help would be appreciated.
> Tony
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.