Is there a way to load a form based on a value in a table? I don't want a menu showing all the forms that are available, only a specific form based on the value in a table. I simply need a way for a user to immediately return to the form they were in the last time they used the db.
I currently have a table that is updated by a query each time another form in the db is opened. It therefore only contains 1 field and 1 record at any point in time. Each user has their own copy of the db (they are not all sharing).
I haven't used Access in years so my knowledge of code etc is very vague.
I've spent days trying to get this to work. I've tried hyperlinks, command buttons, subforms (trying to make them visible/ invisible) etc. The only other thing I can think of is to set up a password system whereby a user records a code on the form they are working on and inputs this to load the form at startup.