Conditional Macro won't run

  • Thread starter Thread starter Tang via AccessMonster.com
  • Start date Start date
T

Tang via AccessMonster.com

Hi, I need help with this.
I have a conditional macro which is linked to a txtbox [txtHospitalNumber] on
a form with on Enter Event. The Macro itself has a condition:
[Forms]![frm18 wks RTT without a Start Date]![txtHospitalNumber] Is Not Null,
set value [tbl18 Week RTT Patients Received Without a Start Date]![Last
updated] date()
[Forms]![frm18 wks RTT without a Start Date]![txtHospitalNumber] Is Null, set
value [tbl18 Week RTT Patients Received Without a Start Date]![Last updated]
Null
[Last Updated] is a seperate date field in the table

when I run the Macr on its own, i get the message saying can't find the name
[tbl18 Week RTT Patients Received Without a Start Date], but I am sure it
does exist in the db. It also won't work on the form either.

thanks
 
Sorry, I've work it out myself. The Set value needs to be a data field on
form.
Hi, I need help with this.
I have a conditional macro which is linked to a txtbox [txtHospitalNumber] on
a form with on Enter Event. The Macro itself has a condition:
[Forms]![frm18 wks RTT without a Start Date]![txtHospitalNumber] Is Not Null,
set value [tbl18 Week RTT Patients Received Without a Start Date]![Last
updated] date()
[Forms]![frm18 wks RTT without a Start Date]![txtHospitalNumber] Is Null, set
value [tbl18 Week RTT Patients Received Without a Start Date]![Last updated]
Null
[Last Updated] is a seperate date field in the table

when I run the Macr on its own, i get the message saying can't find the name
[tbl18 Week RTT Patients Received Without a Start Date], but I am sure it
does exist in the db. It also won't work on the form either.

thanks
Click to expand...
 
Back
Top