After update event

[mitchy1111]

Hi All,

New to the forum and having been trying to solve this relatively simple problem for ages.


I have a form called "Planning" with 2 fields - "Status" and "Start Date".

All I need is for the status on the form to update to "Planned" when a date is entered into "Start Date".

I am struggling with the syntax on the afterupdate event ( I think that is where I should be focussing??)

Many Thanks

Martin

 

[ghudson]

In the AfterUpdate event for the Start Date text box, try this...

Me.txtStatus.Value = "Planned"

Assuming the Status text box is named txtStatus.

 

[mitchy1111]

Thanks. Did the job nicely