A
ATSBC03
I have basic information below of the setup of my database:
I have a form (ptinfo) with tab controls (info),(incident),(complaint). On
the incident tab I have a subform (occurence) where I have another tab
control with tabs(incident,lab,risk,etc.). There are text boxes that hold
inputed dated on each of the tabs and forms etc. I am running into problems
with referencing the controls on the subform. I understand and have
sucessfully used the subform references and am unsure what I am doing wrong.
I also have another form (search) bound to the same recordsource as ptinfo.
I am attempting to search records from all tables/forms and compile a list of
items searched that match in datasheet/continuous view on the search form.
I have previously had all of this working and it wasn't until I added the
subform that it quit. I am not getting #Name error in my text boxes on the
search form.
I know that it is most a referencing problem and I have tried all
combinations that I could think of and combinations from the discussion
groups and other help sites and still cannot seem to make it work. I would
appreciate any help that I can get.
Please find a brief summary of what I am trying to do below.
tblRisk - Main record source for search and ptinfo
ptinfo-incident-occurence-datereported (field i am attempting to reference)
Search - rptdate (field that I am trying to show data in)
If something doesn't make sense or you need more information please let me
know.
I have a form (ptinfo) with tab controls (info),(incident),(complaint). On
the incident tab I have a subform (occurence) where I have another tab
control with tabs(incident,lab,risk,etc.). There are text boxes that hold
inputed dated on each of the tabs and forms etc. I am running into problems
with referencing the controls on the subform. I understand and have
sucessfully used the subform references and am unsure what I am doing wrong.
I also have another form (search) bound to the same recordsource as ptinfo.
I am attempting to search records from all tables/forms and compile a list of
items searched that match in datasheet/continuous view on the search form.
I have previously had all of this working and it wasn't until I added the
subform that it quit. I am not getting #Name error in my text boxes on the
search form.
I know that it is most a referencing problem and I have tried all
combinations that I could think of and combinations from the discussion
groups and other help sites and still cannot seem to make it work. I would
appreciate any help that I can get.
Please find a brief summary of what I am trying to do below.
tblRisk - Main record source for search and ptinfo
ptinfo-incident-occurence-datereported (field i am attempting to reference)
Search - rptdate (field that I am trying to show data in)
If something doesn't make sense or you need more information please let me
know.