I
Imran J Khan
For form 'Pyfrom', I am trying to automatically select the value of list
control 'CP1000' based on the date value entered for the txt box control
'PY1010'. The date entered for PY1010 is to be matched with dates on a
seperate table ('CPtbl') to determine which peroid that date falls in. The
Autonumber (also 'CP1000') of that period then needs to be automatically
selected as the value for CP1000 on the form. When I use a macro in control
PY1010 with a setvalue statement using the following SQL, a dialogue box asks
for the following value [CPTBL].[CP1000]. I guess it can't find the table or
some thing. I know I can reference the form it self with me!controlname etc.,
but how do I reference a table? Help! Am I on the right track? What am I
doing wronge?
Imran
control 'CP1000' based on the date value entered for the txt box control
'PY1010'. The date entered for PY1010 is to be matched with dates on a
seperate table ('CPtbl') to determine which peroid that date falls in. The
Autonumber (also 'CP1000') of that period then needs to be automatically
selected as the value for CP1000 on the form. When I use a macro in control
PY1010 with a setvalue statement using the following SQL, a dialogue box asks
for the following value [CPTBL].[CP1000]. I guess it can't find the table or
some thing. I know I can reference the form it self with me!controlname etc.,
but how do I reference a table? Help! Am I on the right track? What am I
doing wronge?
Imran