Multiple open forms using same table

[ScottK1396]

I designed an Access frontend to handle processing computer upgrades using SharePoint tables. For each major task area (User Interview, Build, Maintenance) I basically cloned a single base form and adjusted presentation and command and whatnot

Central to this is a picklist of computers. most of the string for the RowSource is contained in Public variables, and task-specific filters are concatenated locally. This is further filterable by Office and Type of Upgrade. Changing one of the comboboxes alters the SQL string used for computerlist.RowSource, and triggers a computerlist.Requery.

However, many techs keep more than one form open. What they've noticed is that when when changing the filters on one form, then moving to the next and refreshing the data, the filter they altered on one form now is now applied on the other.

As I've pretty much replicated a base form to make three, are there some sort of violations made in replicating code within the same Access file? should I have renamed my variables, controls and objects on a per-form basis? if I declare a variable within a form (e.g., "Dim WLText as String"), is it viewable across the Access session globally?

Thanks in advance for your input.

 

[BigHappyDaddy]

First, locally declared variables in a form are not accessible across other forms.

Second, if the techs are changing some of the criteria that is being housed in the public variables, then when they move from form to form, the second form will reflect the same criteria as the first form (public variables criteria).

Could that be the situation here?