use combo box selection as source for text box

[mdavid]

Hi, I have a combo box with the following query:



SELECT MempSpecies.SpeciesName
FROM MempSpecies
WHERE (((MempSpecies.SpeciesID)<600));

the MempSpecies table also contains the field Family

Family and SpeciesID appear as text boxes. What do I need to write in Control Source for these fields to receive the values from the selected record in the combo box?
Thanks for any help
David

[June7]

Include SpeciesID and Family as columns in the combobox.

SELECT SpeciesID, SpeciesName, Family FROM MempSpecies WHERE SpeciesID<600;

Then reference the combobox columns by index. Index begins with 0 so if data is in column 2 the index is 1. Expression in textbox ControlSource property:

=Comboboxname.Column(1)

Really should save SpeciesID not SpeciesName.

[mdavid]

Thanks for the quick reply, I only want to see SpeciesID and SpeciesName in the combo box. I need family to appear in a separate text box, so with the above query how many columns does the combo box have? Is it 3 with Family column width 0?

[June7]

3 columns and any column you want to hide should be width 0.

Only the fields not set to 0 will display in the list. The first column not set to 0 will show in the box. The BoundColumn will be save to field.

[mdavid]

Hi, the Combo box name is cmdMempSpecies


the Family control source is: =[cmdMempSpecies].[Column](2)

in the Family text box I receive: #Name?


​What am I doing wrong?

[June7]

cmd is usually a prefix for a command button, not a data control.

Access does not find combobox named cmdMempSpecies.

[mdavid]

Thanks very much, seems I'm a bit dyslexic, my combo box is called cmbMempSpecies.

Now all's working perfectly.

Thanks again