Open form to set option

[Voodeux2014]

Here is what I would like to do. I have separate tables for devices and employees. I have separate forms for each (adding new or editing). I have a form to where you can select an employee and a device and save the record s that we know who a device is assigned to. Each user in my company has a system that only they use. I have set it up to where you are able to add multiple devices in a row, if needed. The feature I would like is to have this form auto select the employee based on the open form employee that is selected. Is it possible to do this?

[Missinglinq]

...I would like is to have this form auto select the employee based on the open form employee that is selected...

As Dave Letterman would say..."What?" You want to select the employee based on the employee selected? Are you saying you want the Records for the devices assigned to a given employee to be retrieved? If so, you place a Subform on your employee Form and base it on the devices Form, connected by a common Field, which would usually be an employee ID Field. As you move from employee to employee, their devices will update, accordingly.

Linq ;0)>

[Voodeux2014]

Sorry, may have not explained it enough. On my form "frmMainMenu" you can select an employee and it will auto filter a few queries to display assigned devices and such. I have a separate form that you open from the main menu form to either add an employee or add a device ("frmAddEmployee" and "frmAddDevice"). There is an additional form ("frmAssignDevices") to where you can select an employee from a combobox and select a device from a separate combobox. I would like the form "frmAssignDevices" to open up and already have the employee selection combobox set to match that to what is already selected on "frmMainMenu"

[amalfatima]

is there a follow up question? The only thing different is that you are allowing the users to select their name so instead of having to use dlookup to find their employee ID you can just adopt the value of the combo box assuming you are using an autonumber as the primary key of the table and it is also the bound column of yo


amal

[ssanfu]

where you are able to add multiple devices in a row

This sounds like yo do not have a normalized table structure.

How are you opening "frmAssignDevices" from "frmMainMenu"? A button with code?
If you are using the command "DoCmd.OpenForm", use the "WHERE" clause of the command.
Something like:

DoCmd.OpenForm "frmAssignDevices", , , "empID = " & Forms!frmMainForm.cboEmployee

(Change empID to your field name)

[Voodeux2014]

Sorry for the late response. This did not work for the way my database is set up. What I instead did was create an Append query that captures the empID from frmMainMenu and the devID from FrmAssignDevices and append it to tbl3Employees_Devices.