Unanswered: Form default value from a record in a table
Hi, I would like to define the default value of a form text box from a record in a table.
I tried to tyoe in the following in the default value box of my form's text box:
= SELECT [Table1]![field_for_default_value] FROM [Table1] WHERE ((([Table1]![2nd_field])='whatever'));