View Full Version : How to SetValue in a subform?


Thomas Anderssen
02-22-2000, 03:08 AM
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
02-22-2000, 05:46 PM
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.

Thomas Anderssen
02-22-2000, 11:20 PM
Yeah! It worked! Thanx a million!
*Happy*
Thomas