How do I autofill a value in one field based on the value of anoth

G

Guest

Access 2003
1) I have a form with the fields IYD, RevIYD, NeedDt and a chkbox named
"NonSupport".
I need for the check box to autofill to true when both the IYD and RevDt
fields are greater than the NeedDt.

2) On this same form I have another chkbox named "Closed" and a ClsdDt
field, I need the ClsdDt field to autofill with the date when the chkbox is
checked to true.
 
G

Guest

Question 1
Create a sub that you can call from the After Update event of the IYD,
RevDT, and NonSupport controls:

If Me.IYD > Me.NeedDt And Me.RevDT > Me.RevDt Then
Me.NonSupport = True
Else
Me.NonSupport = False
End If

Question 2.
In the After Update event of Closed:
If Me.Closed = True Then
Me.ClsdDt = Date()
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checkbox problems in a form 1
autofill of check boxes not working on first new record 1
Colour Row in Continuous Form in Access 97 1
Autofill field based on values from another table 1
Default value on continuous form from query 2
Autofill Form Error 13 Type Mismatch 6
default value for one field based on another 2
AutoFill Module 2

Top