How to SetValue in a subform? (1 Viewer)

T

Thomas Anderssen

Guest
Hi. Have a listmode subform in my main form. When an user changes field A value (numeric) in any way, I want to make a checkbox ticked and a date field to show Date(). Please help me with the correct macro/syntax for this to happen...

TIA, Thomas
 

Axis

Registered User.
Local time
Today, 11:39
Joined
Feb 3, 2000
Messages
74
How about something like this:

In the AfterUpdate property for Field A put

Me![Checkbox].Value = True
Me![Date Field] = Date()

This works if all of the fields are on the same form. Otherwise you'll have to use the Forms![Form Name]![Field Name] syntax.
 
T

Thomas Anderssen

Guest
Yeah! It worked! Thanx a million!
*Happy*
Thomas
 

Users who are viewing this thread

Top Bottom