Default value on form coming from another table

  • Thread starter Thread starter Geraldwho
  • Start date Start date
G

Geraldwho

i would like to have the default value for my Inspector field on my
InspectionForm form come from my CompanyInfo table from a field called
Definsp. Since this table only has 1 record, can i get this value and pass it
on to the form control as a default value?
 
yourformcontrol= nz(dlookup("Definsp", "CompanyInfo"),0)

check out dlookup in help.

Damon
 
i would like to have the default value for my Inspector field on my
InspectionForm form come from my CompanyInfo table from a field called
Definsp. Since this table only has 1 record, can i get this value and pass it
on to the form control as a default value?
Click to expand...

Set the textbox's DefaultValue property to

=DLookUp("Definsp", "CompanyInfo")
 
Back
Top