POPUP Form Problem

  • Thread starter Thread starter Jonathan Smith
  • Start date Start date
J

Jonathan Smith

I am using Access 2002, in a Windows XP Client/Windows 2000 Server
environment.

I have a Form (frm2020_01) that contains the following pertinent fields:

cboTherapist
cboPatient
txtSvcDate
cboActivity
txtBegTime
txtEndTime

Based on the value of the cboACtivity, a second Form (frm2020_09) will
POPUP after cboActivity has Lost_Focus. The Second Form (frm2020_09) has
the following pertinent fields:

cboTherapist
cboPatient
txtSvcDate
txtBegTime
txtEndTime

I would like to have the Values from Form One (frm2020_01) automatically
update the Values in Form Two (frm2020_09), where appropriate -- i.e.

Me("cboTherapist") = [Forms]![frm2020_01].[cboTherapist]
Me("cboPatient") = [Forms]![frm2020_01].[cboPatient]

Great theory, but I am sorely lacking the implementation.

Help please!!!

--
Jonathan Smith
Information Technologies Consultant
Spheniscidae
POB 61741
Phoenix, Arizona 85082-1741
602-758-9822
(e-mail address removed)
 
Your code should work, assuming the forms are opened. Call your code in the
Open event of frm2020_09
 
Your code should work, assuming the forms are opened. Call your code
in the Open event of frm2020_09

Thanks for the help, but that idea resulted in an error stating it could
not find the form frm2020_01.

Any further ideas would be great.
 
Back
Top