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")
 

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

Pls Help - default value in a subform 1
Need combo box to refresh when moving to new record 2017 1
Combo Box Lookup 3
Data entry for a table from a form 1
Unbound Combo Box Default Value Based on Query 10
Default Value to a Specific Date 2
Default value last value entered? 3
lookup question 1

Back
Top