Urgent Help Please!!

[de049]

I have a form which displays employee records. Each record consists of a surname, first name,department. Ialso have a list box containing the names of all employees. How do i make the record for the employee chosen from the list box appear. Up to now i have only managed to get the Surname to change its value when selecting from the list. The firstname and department boxes DO NOT change

Please help.

'D'

 

[Rich@ITTC]

Hi de049

Well let's start by checking a few things. You need to have surname, firstname, department as textboxes/fields on your form.

Then elsewhere, normally in a form header, you add a combo box (like a list but a dropdown version) created with the Controls Wizard selected. This will give you the choice, on the first screen of the Wizard, of selecting "Find a record on my form based on the value I selected in my combo box" ... and if you follow this through it will create all the coding and the combo box to do what you want.

What you were doing, from what I understand of your description, was changing the surname of a record via a list box (i.e. altering the actual data).

HTH

Rich Gorvin