If statement with a counter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 03 / 2000 format

How do I, in a button command on a subform, read a counter in a different
subform and add a Yes to a field if the counter = a certain number or add yes
to another field if the counter = another number?

Mainform = frmTardyAdd
Sub1 = subTardyCounter
Sub2 = subDhall

Field1 = tblDhall.Step1 Yes/No I need a Yes here if the counter =8
Field2 = tblDhall.Step2 Yes/No I need a Yes here if the counter =10

I know I need an If statement, but I don't know how to write one that would
read the other value from the subform
 
Ripper said:
Access 03 / 2000 format

How do I, in a button command on a subform, read a counter in a different
subform and add a Yes to a field if the counter = a certain number or add yes
to another field if the counter = another number?

Mainform = frmTardyAdd
Sub1 = subTardyCounter
Sub2 = subDhall

Field1 = tblDhall.Step1 Yes/No I need a Yes here if the counter =8
Field2 = tblDhall.Step2 Yes/No I need a Yes here if the counter =10

I know I need an If statement, but I don't know how to write one that would
read the other value from the subform
Click to expand...


Try using:

Me.Step1 = (Parent.subTardyCounter.counter=8)
Me.Step2 = (Parent.subTardyCounter.counter=10)
 
Back
Top