Text Box - Default Value

  • Thread starter Thread starter Buddy
  • Start date Start date
B

Buddy

I don't understand how to make the default value of text box 'a' to be that
of table 'b'. table 'b' is called 'default_year' and only contains a single
entry '2004' (which i can update), i would like text box 'a' in form
'inventory' to default to what every value is in table 'default_year'.
Anyone know how this is done?

I tried '=[Default_Year]![Default_Year]' in the Default Value field but just
get an error.

Any other suggestions would be appreciated.

Thanks.
 
Buddy said:
I don't understand how to make the default value of text box 'a' to be that
of table 'b'. table 'b' is called 'default_year' and only contains a single
entry '2004' (which i can update), i would like text box 'a' in form
'inventory' to default to what every value is in table 'default_year'.
Anyone know how this is done?

I tried '=[Default_Year]![Default_Year]' in the Default Value field but just
get an error.

Any other suggestions would be appreciated.

Thanks.
Click to expand...
Try =DLookup("Default_year","Default_year")

Tip: do read the Help for DLookup.
 
Back
Top