Help! Referencing a Subform from another Form

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top