Returns Null based on Column?

G

Guest

Me.OrderContactID = Me.ActiveControl.Column(9)
Me.BillToAccount = Me.ActiveControl.Column(10)


I am trying to set a textbox, on my form, based on the vaule in a cloumn
from the dropdown box. Column 9 will display data but column 10 comes up
null.

The first time I run this the value 110 will display from column 9 but the
value 4010 that is in column 10 will show a null value when I togel the break
point there.

The next time I moved the colums around and the value 4010 will display from
column 9 but the 110 value in column 10 will show as null.

Is there a limit to the number of columns you can use in this procedure?

Thanks in advance
 
G

Geof Wyght

cvegas,
Column numbers are zero-based. So, if you have 10 columns,
you count from 0 to 9. If column 9 always returns a value
and column 10 is always null, perhaps that's the cause.
Good luck.
Geof.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top