Default value on form coming from another table

[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?

 

[Damon Heron]

yourformcontrol= nz(dlookup("Definsp", "CompanyInfo"),0)

check out dlookup in help.

Damon

 

[John W. Vinson]

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?

Set the textbox's DefaultValue property to

=DLookUp("Definsp", "CompanyInfo")

 

[Geraldwho]

thanks. i got hung up with the syntax. (again)

yourformcontrol= nz(dlookup("Definsp", "CompanyInfo"),0)

check out dlookup in help.

Damon