Populating form fields

[jb2606]

I have a form based on a table named <Staff>. The fields in the form are StaffID, Surname, Name, Grade. What I am trying to achieve is that when a particular StaffID is selected, the other corresponding fields (Surname, Name, Grade) are filled up automatically. Could anyone assist? Thanks.John.

 

[RuralGuy]

Have you used the ComboBox wizard to create a ComboBox that will look up a record for you?

 

[jb2606]

Populating fields in a form.

Yes i have tried the combo box wizard. But what i need to achieve is to get the seperate records for a particular ID.
Example, when I choose Staff ID 111, in a seperate text box I need the name to be displayed automatically, in an other seperate text box the surname and so on...

 

[kilobyte]

So what you're saying is that you need to populate the controls with fields from two different records? Did I read that right?

 

[jb2606]

Populating fields in a form

Yes. You are right.

 

[kilobyte]

I still don't understand. From what I know, I don't see why you'd do that or even if it's possible. Maybe we're confusing terms here. A record is like a row from Excel, and in this case all the records for your form are coming from the table named Staff. So the table looks like this?

Staff
StaffID Surname Name Grade
1       Smith     Bob    AA      <----------This row is one record.
2       Jones     Mary  AAA

I am just looking for clarification here because I think I know how to do what you're asking.

 

[jb2606]

Exactly..thats what i mean.

 

[kilobyte]

When you open the combo box wizard, choose the third option, "Find a record on my form, based on the value I selected in my combo box." That does exactly what your trying to do.

 

[jb2606]

Thanks X100