J
julie
I am in the process of creating a database. In the database I have a medical
record that is assigned to each resident that we have here. You are not
allowed to assign this number to another resident which I have used to link
my two tables together. I have a table called Residents and then I have a
table called Reportable Events. I am pulling the information from the
Resident table and the Reportable Event table from a query to generate a
report. Since I am able to tie the two table together through a query then I
do not have to enter the Resident Name on the form for Reportable Events, but
what I did do was add a subform to the form with this Medical Record Number,
Resident Name to be sure that when I enter the Medical Record number it is
for the correct person. What I want the subform to do is once I enter the
Medical Record number on the form I want it to automatically show up on my
subform to validate I have the correct Medical Record Number for that person.
I opened up the subform in design view and tried to go to proprieties of the
Medical Record and then go to the tab for events and built a query like
this=Forms![Reportable Events Year 2006]![Medical Record #] received an
error like this when I try to get out The expression on enter as the event
property setting produced the following error: Mirosoft Office Access can't
find the form "Reportable Events Year 2006 referred to in a macro expression
or Visual Basic code. What are they talking about? How can I fix it so I
will not be getting this message. I appears to be working correctly on my
form but afraid that since I am receiving this message it will eventally mess
up.....Thanks Julie
record that is assigned to each resident that we have here. You are not
allowed to assign this number to another resident which I have used to link
my two tables together. I have a table called Residents and then I have a
table called Reportable Events. I am pulling the information from the
Resident table and the Reportable Event table from a query to generate a
report. Since I am able to tie the two table together through a query then I
do not have to enter the Resident Name on the form for Reportable Events, but
what I did do was add a subform to the form with this Medical Record Number,
Resident Name to be sure that when I enter the Medical Record number it is
for the correct person. What I want the subform to do is once I enter the
Medical Record number on the form I want it to automatically show up on my
subform to validate I have the correct Medical Record Number for that person.
I opened up the subform in design view and tried to go to proprieties of the
Medical Record and then go to the tab for events and built a query like
this=Forms![Reportable Events Year 2006]![Medical Record #] received an
error like this when I try to get out The expression on enter as the event
property setting produced the following error: Mirosoft Office Access can't
find the form "Reportable Events Year 2006 referred to in a macro expression
or Visual Basic code. What are they talking about? How can I fix it so I
will not be getting this message. I appears to be working correctly on my
form but afraid that since I am receiving this message it will eventally mess
up.....Thanks Julie