Default Value To Be Entered On a Form

  • Thread starter Thread starter Jeff Garrison
  • Start date Start date
J

Jeff Garrison

Here's a good one -

I have a database that is split using front end/back end. I have to make
default changes on the year periodically for the users. What I want to do
is to have a table on the back end that I can change the default year so
that all of the forms will display and use the year that is stored in the
Year table. How can I use VBA to display and use whatever in is that table
stored on the back end? I've tried using the Default Value property for the
field (which is unbound), using the syntax [tblDefaultYear]![DefaultYear],
but all I get is the #Name?.

Any help would be greatly appreciated.

Jeff
 
Jeff Garrison said:
Here's a good one -

I have a database that is split using front end/back end. I have to make
default changes on the year periodically for the users. What I want to do
is to have a table on the back end that I can change the default year so
that all of the forms will display and use the year that is stored in the
Year table. How can I use VBA to display and use whatever in is that table
stored on the back end? I've tried using the Default Value property for the
field (which is unbound), using the syntax [tblDefaultYear]![DefaultYear],
but all I get is the #Name?.
Click to expand...


Look in help file for DLookup()
 
Here's a good one -

I have a database that is split using front end/back end. I have to make
default changes on the year periodically for the users. What I want to do
is to have a table on the back end that I can change the default year so
that all of the forms will display and use the year that is stored in the
Year table. How can I use VBA to display and use whatever in is that table
stored on the back end? I've tried using the Default Value property for the
field (which is unbound), using the syntax [tblDefaultYear]![DefaultYear],
but all I get is the #Name?.

Any help would be greatly appreciated.

Jeff
Click to expand...

The year table has just one record?
The value is stored as just the year, i.e. 2003, not a full date?
As default value in the control on the form:
=DLookUp("[txtYear]","tblYear")
 
That worked! Thanks again for the help.


fredg said:
Here's a good one -

I have a database that is split using front end/back end. I have to make
default changes on the year periodically for the users. What I want to do
is to have a table on the back end that I can change the default year so
that all of the forms will display and use the year that is stored in the
Year table. How can I use VBA to display and use whatever in is that table
stored on the back end? I've tried using the Default Value property for the
field (which is unbound), using the syntax [tblDefaultYear]![DefaultYear],
but all I get is the #Name?.

Any help would be greatly appreciated.

Jeff
Click to expand...

The year table has just one record?
The value is stored as just the year, i.e. 2003, not a full date?
As default value in the control on the form:
=DLookUp("[txtYear]","tblYear")
Click to expand...
 
Back
Top