Default Value To Be Entered On a Form

[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

 

[Rick Brandt]

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

Look in help file for DLookup()

 

[fredg]

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

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

 

[Jeff Garrison]

That worked! Thanks again for the help.

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

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