retrieving data from unlinked tables

[silverstriip]

I have a table (Working_Year) that is storing a single field which is the year (current_year) that is selected by the user in my initial form when the database is loaded. Am I able to use that data in other forms and reports with out linking the table? I would like to simply display the current_year the user is working in a textbox somewhere on the forms (example form named: "Main Entry") and use the current_year as a filter on reports (example report called "Gifts - by Type").

 

[Remou]

Do you mean without binding the table? If the table is in the current database or is linked to the current database, you can use DLookUp. If not, you can use a query (with IN) or ADO.

 

[SeeThru]

If it is selected in a form, instead of lcosing the form, sets its visible value to false

me.visible=false

The you can still refer to the form to get the value

Frm_OnOpen
mylabel.caption=forms!YearSelect!YearSelected