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

  • Thread starter Thread starter David
  • Start date Start date
D

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
 
David said:
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.
Click to expand...

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.
 
EUREKA, you found it! Thanks

Rick Brandt said:
David said:
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.
Click to expand...

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.
Click to expand...
 
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
 
Back
Top