Getting Zip Code from Combo Box

[Sandra]

I am using the statement =GetName.column(x) in some form
controls to obtain data from a combo box. Everything
works fine except the zip code. In the underlying table
it is formatted as 12345-9876. Is there something else I
must do to get the zip code?
TIA,
Sandra

 

[Scott McDaniel]

Post the code to your GetName routine.

 

[Sandra]

That's what I'm doing, but it doesn't show up:
=GetName.column(7) should give me the zip code, but it is
blank. I thought there might be a formatting problem or
something else I must do.
Thanks,
Sandra

 

[Jim Allensworth]

Do you really have 8 columns in your combobox?

Remember the ColumnCount is zero based, so you might take a look at
that.

- Jim

 

[Bill Crawford]

also if you have an ID field it can throw the count off too

 

[Jim Allensworth]

Really? A column is a column. A combobox doesn't distinquish between
datatypes. Or are you thinking of something else?

- Jim