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
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