Auto Populate

[Guest]

I am trying to auto populate a field based on what was chosen in the combo
box. In the box that I want the information to auto populate in I am using
the following:

=[cboRptName].[Column](2)

but nothing is showing up. Is this the correct thing to use or should I be
going in a different direction?

 

[Guest]

The column count start with 0, so if the value you need located in the second
column

Select ID, Description From TableName

Then it need to be
=[cboRptName].[Column](1)
***************************************
Also, if you need the third column, check the Column count of the combo that
it has 3 or more in it.
***************************************
Where do you use that?
It need to be in the ControlSource of the Text Box

 

[Arvin Meyer [MVP]]

First make sure that your columns are correct. Column(2) is actually the
third column, so you need to have 3 (or more) columns defined in your column
count, and your column measurements (even if those measurements are 0)

 

[Guest]

I'm also getting the following error message : The methord you tried to
invoke on an object failed.

I did notice that if I change the column number then the info in that column
populates.