Saving a Form

[Keefay78]

Since my last post I have managed to make some tables and run a form from it, so far so good, I now have a page where I have a few comboboxes on a layout that each department in my work can input whatever member of staff they want in that role however when the database is closed the fields are reset. I would like it to be saveable so each dept can fill their part in and the data can be used for contact purposes.

I realise there have been other posts about saving forms and I realise that saving forms as is is not possible (or straight forward) but I dont want to rehash an old thread for something that might have been solved in the meantime. I am having to use Access 2007 as thats what is currently on the shared workspace in the company.

If need be I can upload a zip of the database for your parousal, its still very small only a couple of contacts added for list testing purposes.

 

[Ranman256]

why are you changing forms that much? you design the form ,then the users work on it. They dont save the form, they save the data.
Forms are not to be changed in a single db with many users on it.

 

[Keefay78]

I don't think I'm changing forms really, probably the selections on it.
I havea database containing tables with staff names/numbers from each dept, I created a form with a breakdown for each dept to pick who is on call that day, along with their contact number, that way at any given point you could see who is on call and have a contact number at hand.
So far so good..
Each dept uses the combo boxes and selects people and ideally that selection would stay there until a new one was started fresh for the next day.
I appreciate that forms are just requests and that the information doesnt stay there but im hoping that either a: it can be made to stay there with some commands or find out if there is a way where every department who uses the form populates some table elsewhere that can be accessed for a list of names and contact details. (and probably even have such a list prined off.. but that is way down the line)