Is it possible to assign values to variables, in code (such as the On Open event) using a standard SELECT statement? I'm aware that RunSQL only works for action queries, and so am at an impass. The scenario is that I have a table, which either contains valid records, or does not. I need to query the table, for valid records, and return a null or a value. I'm thinking I may be able to use a record count, in place of the Select statement, but at this point my brain is toast, and I can't seem to come up with anything to use. Any help would be appreciated.