Default Value's correct syntax

  • Thread starter Thread starter DennisP
  • Start date Start date
D

DennisP

I have a combo box which I want the previous value
automatically copied over when they click add new record.

What would be the correct syntax?

Me.cbotwo_month_goal.DefaultValue = IIf(IsNull(rslast
("two_month_goal"), "", rslast("two_month_goal"))

What about dates?
Me.txtAdditional_Visit_Dt.DefaultValue = IIf(IsNull(rslast
("Additional_visit_dt")), "", rslast
("Additional_visit_dt"))

Please help. Thanks.
 
Back
Top