Hello there,
I really need some help please from some of you extremely talented people!
I am designing a new access based database for my team and i've come across an issue that i've spent hours and hours on that i just can't seem to get right even after following guide after guide.
I have attached an extremely watered down version of the database as the full version includes a lot of personal information for you to have a look at if possible.
Basically, my team looks after around 30,000 users, managing access to systems via a smartcard and we need to keep track of the access each user has. Users move around and receive access to a different organisation every day. This is what I need to capture.
In this version i have created just one test user, each user has a UUID and for this test user the UUID is 883918982017, if you search for this user on the reg users form their details will be displayed along with the access they currently have.
I need to be able to add a new position to this user via a combo box that you would enter the organisations code which then would show the correct positions for that organisation in another combo box and when i click on the correct position it updates the link table in the background in turn adding it to the list of positions assigned to the user. ( I really hope i'm making some sort of sense!)
I created the form frmAssignPos to be used as a subform which works if you open that form on it's own but if used as a subform it always asks for a parameter value before displaying the list of positions?
Any help would be greatly appreciated, i'm just stuck and it's hurting my head!
Kind regards
Lee