Default values in access forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to set the defaul;t value in the form to the value in another table.
eg the default value for the year to be 2005. if this is a value in another
table then the default value in various forms can by updated by changing the
value in the table.
 
merlinchris said:
i want to set the defaul;t value in the form to the value in another
table. eg the default value for the year to be 2005. if this is a
value in another table then the default value in various forms can by
updated by changing the value in the table.
Click to expand...

Use a DefaultValue setting of...

=DLookup("FieldName","TableName")
 
You must log in or register to reply here.

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

Default Value on Form Help 1
how to set the Default Value of a Control Box to a Lookup Table 0
link field main form and subform 5
Table Default Values 1
Override default value sourced via Dlookup? 3
How to change Default Value on Form 3
User Sets Control Default Value 1
Do Not Display Default Value 8

Back
Top