Auto Complete fields

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have one table with Workday_Type, Shift and District, they are all combo
boxes. If Workday_Type does not equal "Workday" or "OverTime Day" I would
like to auto fill Shift and District to "None". The Shift combo box uses a
value list and the district combo box uses a table/querry.

Thank you

Frank
 
Frank,

In the AfterUpdate event of Workday_Type, enter this code (typed but not
tested)

If Me.ActiveControl <> "Workday" and Me.ActiveControl <> "Oevertime Day"
then
[Shift] = "None"
[District] = "None"
End If


God Bless,

Mark A. Sam
 
Mark,

That works great, thank you.

Mark A. Sam said:
Frank,

In the AfterUpdate event of Workday_Type, enter this code (typed but not
tested)

If Me.ActiveControl <> "Workday" and Me.ActiveControl <> "Oevertime Day"
then
[Shift] = "None"
[District] = "None"
End If


God Bless,

Mark A. Sam

Frank said:
I have one table with Workday_Type, Shift and District, they are all combo
boxes. If Workday_Type does not equal "Workday" or "OverTime Day" I would
like to auto fill Shift and District to "None". The Shift combo box uses
a
value list and the district combo box uses a table/querry.

Thank you

Frank
Click to expand...
Click to expand...
 
Back
Top