using Me!ShipName = Me![CustomerID].Column(9) won't work

[David]

I use this format in the data of a text box:
Me!ShipName = Me![CustomerID].Column(1)

It stops working after (7), but my query goes up to 12 columns.

What can I do

 

[Rick Brandt]

I use this format in the data of a text box:
Me!ShipName = Me![CustomerID].Column(1)

It stops working after (7), but my query goes up to 12 columns.

Assuming CustomerID is a ComboBox what have you set the ColumnCount to? It has
to be the same as the number of fields in your query.

 

[David]

EUREKA, you found it! Thanks

I use this format in the data of a text box:
Me!ShipName = Me![CustomerID].Column(1)

It stops working after (7), but my query goes up to 12 columns.

Assuming CustomerID is a ComboBox what have you set the ColumnCount to? It has
to be the same as the number of fields in your query.

 

[TC]

I don't think anyone will understand your question as it is currently
worded.

What do you mean by using this "format" in "the data of a textbox"?

What "stops working"?

The .Column property does not apply to textboxes, so you have definitely not
told us the full story of what are the controls that you are working with.

HTH,
TC