IF then

  • Thread starter Thread starter penrithau
  • Start date Start date
P

penrithau

I have a form, I would like to automate answers, I have no idea about
codes, but this is it,

I have 4 fields, if field 1 is true then I would the other fields to
automatically return a No or False.

But if the field is false then field 2 would be true.
 
penrithau,
Both situations rely on the value of Field1, so... on the AfterUpdate event of
Field1...
Assuming all fields are True/False... and all on the main form.
(You didn't indicate what Field3 and 4 would be if Field1 = False, so I'll assume they
stay False in both conditions)

Private Sub Field1_AfterUpdate()
If Field1 = True Then
Field2 = False
Field3 = False
Field4 = False
Else
Field2 True
Field3 = False
Field4 = False
End If

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Back
Top