Conditional Macro won't run

[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

 

[Tang via AccessMonster.com]

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