Tweaking my database

[Voodeux2014]

I have rebuilt my database from the ground up after learning new techniques to store data and whatnot. I have attached my database so that you can review it in order to understand what is going on and what I would like to happen, if possible. Just a little fyi about this situation is that it is a multiple part question, So here goes:

I want my "Main Menu" form to be displayed at all times. I have it set up to where the user can select an employee in a dropdown menu and it autopopulates the form with that employee's information and assigned assets so on and so forth. I have it set to where nothing can be changed on the main form as far as data (to prevent accidental changes). I have set up a form to add an employee and will set up one to add a device and so on. These new forms are set to popup mode.

What I would like to find out is how to make a form for each of the following:

- Editing an employee (having it auto show the employee that was selected on the Main Menu)
- Assigning a device to an employee (the table that this is in only shows numbers, but want the user to see the actual employee name and device information)
- Changing device name
- Change employee's wallport

Any help on these ideas would be greatly appreciated. And also, for the record, I have very minimal knowledge on VBA. I am more familiar with macros but am trying to now learn VBA.

[Voodeux2014]

UPDATE:

I have figured out the Editing an Employee form and have it working. But I would like it to only save the changes if the save button is clicked. IF the cancel button is clicked it will not saving any changes and close the window.

[June7]

That might get tricky. Review https://www.accessforums.net/access/...ent-48322.html

[ssanfu]

7 tables with a PK field "ID"??? Can get confusing.

Form name "qryEmpDevices subform"? Why do forms have a name prefix "qry"?? Better name would be "sfrmEmpDevices". And no spaces in name!
Still looking at the structure.......

[Voodeux2014]

ssanfu,

The reason why those forms had that prefix was because i dragged them on to a form. I have renamed them as you suggested for when i getting better into the actual coding part.