Linking unbound fields?

[brum_rich]

I have created a form which contains an unbound field which is setup as a combo box. I want to display concatenated values from two fields (Surname, Forename) from tblEmployee in the combo box from which a user can select

Once the user has selected the record they want to view there will be command button cmdEditDetails. If they click on this I would like to take them to a new form (frmEditEmployeeDetails) which will display the appropriate information for the employee selected in the unbound field.

Any advice on how I would go about firstly setting up the concatenated values in the combo box, then displaying the appropriate values in the next form?

 

[namliam]

For the combobox use the query of the rowsource where you concatinate using the &

For the opening of the form, look into the "Docmd.openform" command you will find a "Where" and "Filter" option that you can use to open the form on the right employee.

 

[brum_rich]

Thanks for the response.

Soted the combo box...cheers

Fine with the Docmd,open form code although not sure how I link this to teh Where" and "Filter" options you refer to?

 

[namliam]

No you dont link those options, you use them...

in the where option (or filter option) you put something like "[EmployeeID] = " & Me.YourCombobox

This will then open the form with only the one employee there.