Requery problem

[gumbi17]

I am currently having a set of 3 dynamic combo boxes that define what is being inserted into the combo box by what is selected on the first combo box. The problem is that I have numerous users on at once, and when a person makes his selection for the initial combo box the requery works. If someone else is using the same form and selecting a combo box after they have, not the next set of boxes have their results. I tried to do a requery.Abcd on both onclick and mouse down, but all it does is allow the requery the user can not select any of the objects in the comb box. Is there a way to have it requery but then allow a selection inside the combo box?

 

[pr2-eugin]

Did you just say everyone uses the same form at the same time?

 

[gumbi17]

Well the same form but linked to different unique numbers. It is a subform within the form.

 

[pr2-eugin]

Still.. You need to split the DB into Front end that contains all your Forms, Queries and modules and Backend that contains purely your tables. This backend should be placed in a Network location, where all users can have access. The front end is to be distributed and each user needs to have their own personal copy.

There should be plenty of articles on how to split DB, some of them are:

http://www.granite.ab.ca/access/splitapp/overview.htm
http://office.microsoft.com/en-gb/access-help/split-an-access-database-HA010342026.aspx
https://www.fmsinc.com/microsoftaccess/DatabaseSplitter/

Why to split: http://www.techrepublic.com/blog/10-things/10-plus-reasons-to-split-an-access-database/

 

[gumbi17]

So if I split the database, and add a FE each user than the VBA will only effect that specific user? I have split databases before but I dont know all the benefits you can get from it!

 

[pr2-eugin]

So if I split the database, and add a FE each user than the VBA will only effect that specific user?

Yes, only the user who is using the Front End file.

I have split databases before but I dont know all the benefits you can get from it!

I have added a link from TechRepublic on why to split, that highlights the benefits..

 

[gumbi17]

Alright I have split the database, and made the front end a ACCDE so they can not modify any of the forms. I am still getting the problem, and i know it's half the users fault. They have a minimum of 19 answers for the initial combo box that sets the rest of the dynamic combo boxes. So the users pull the 19 min down first and then start reading their information, and analyzing. So all the answers for all of the combo boxes show the answers for the last item selected. Which gets me back to the requery question, how can I have it requery when mouse down or onclick and still have it select the answer?

 

[pr2-eugin]

Move the Code from MouseDown and OnClick, and place it in the After Update of each ComboBox. That is where it should reside.