Keep value constant in query until necessary to change

[naveehgreen]

Hey all,

Right now, I'm using a query by form technique to update some queries of mine with a different value. Is it possible to keep this value constant (i.e., have the form NOT ask me for this value every time I want to run the query) until I decide to change it? I won't be changing the value for about 3 months.



Thanks

[Access_Blaster]

Yes you can have many constants and refer back to them when you need to. The below example would be for a listbox.

Option Compare Database
Option Explicit
 
Const MYRowSource = "SELECT DISTINCTROW RecordID, SomeDate, UserName FROM [MyTable]"

Richard