Call variables from a table

[charityg]

I know what I would like do, I just hope I can explain it right. I have a Client/server database application that is on our network. I plan to split the database, but have the front end forms on the network, and the backend tables on the client hard drives (it absolutely must be this way). Most of my forms work by using public variables, and when more than one user opens the database, the variables start getting overwritten by the actions of the other user. Finally, for my question: Is it possible to store the variable in a table on the users backend and have the networked form call the tables for the variables? How would the code work for this? For example depending on a selection made on the main switchboard, a public variable varSection holds the section that the user selected. The datasource for the next form is based on this variable. If another user logs in a selects a different section my program won't function correctly. Any suggestions are appreciated!!

 

[charityg]

I figured this out on my own. I just wrote a GetSelection function that finds the value in the table, and a SetSelection function that assigns the value. Now I'm having second thoughts about the functionality of the design with a form on the network.