Default Value's correct syntax

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

checking for null 3
Math in fields using values in Document Properties 3
Need help modifying code 0
Including Null values in query design 6
passing value from a form with IIF statement in a query 1
Using IIf + default value for a combo box 4
Help with If statement 17
Substituting blank fields on a form 2

Top