OpenArgs value getting lost.

[grnzbra]

We have two SQL Servers which to which users are assigned on a load leveling program. The Access application opens a form in design mode and creates checkboxes on the form. It then opens the form in normal mode and passes a listing number (this is a real estate office) as an OpenArg.

The OnOpen event opens a recordset using the OpenArg in the where clause. When the user is on one of the SQL Servers, it runs fine, but when the user is on the other, the code in OnOpen event thinks the OpenArgs value is null. However, when we've stepped through the code, we've see that in the OpenForm call, the OpenArgs has a listing value in it.

Just to make life interresting, when the design mode call is given the OpenArgs value, it works fine.

Does anyone have any idea what could be happening?
Or should this be posted in the SQL Server section?

 

[psemianonymous]

All module variables lose their value anytime an unhandled exception is thrown.

Also, maybe you have code that sets the Openargs property somehow?

Or, maybe you have code that 're-opens' the form (which probably won't reset the openargs property)?


Just throwing some ideas out there.

 

[grnzbra]

The same code is copied nightly to both servers.