combo box and populating a field

[giggles7840]

i have built a combo box which holds the firstname and lastname values. what i cant figure out is how to get the selected value from that combo box to populate into the first name/lastname field.

this should be an easy one. please help.
danielle

 

[giggles7840]

right now, it will store the primary kep field and i need it to store the actual value selected.

 

[luceze]

In the after update event of your combo place this code.

me.LastName.=me.YourComboName.column(0)
me.FirstName.=me.YourComboName.column(1)

Change the blue parts to match the names of your controls.

HTH,
Eric

 

[luceze]

Sorry posted before your second post went through.

So you are saying that you want the combo box to store the value or do you have text boxes to store the last name and first name?

Eric

 

[giggles7840]

COOL. now that info is in a main form. is there a way for it to automatically populated into the sub forms?

 

[luceze]

You can reference a subform control by using the following syntax:

me.YourSubFormName.YourControlName

or

forms!YourMainFormName!YourSubFormName.YourControlName

HTH,
Eric

 

[Shingebis]

A few questions before we can get to the answer.

1. Is the combo box based on a query or code?

2. Does the table you are going to store the results in have a field for first name and last name or one joint field for name?

 

[giggles7840]

i created the combo boxes using the wizard based off of the parent table. each table has a first name field and and last name field. i would like the parent first name and last name to populate into the 2 child tables when the main table record is pulled.

 

[giggles7840]

or what would be really cool is for the combo boxes on the main form were search boxes. when the value is selected then the values would auto populated into the sub forms.