Find match record

[mithani]

Hello,

Can anyone tell me how to do:

I have one invoice screen. Using Combo, I can select supplier from the supplier table. What I need exactly, when I select any particular supplier, address, telephone and fax should show at invoice screen. I used this command but seems not correct.

me.address.value = [me.comSupplier,2]

Any help?

thanks

mithani

 

[boblarson]

To reference other columns in your combo box, other than the bound column, you can use:

Me.address = Me.comSupplier(2)

(remember it is zero based so using 2 means the third column)

 

[mithani]

Thanks Bob,

Getting error messages "Type mismatch"

both are text

Thanks

mithani

 

[boblarson]

Each field has to be set up in the table as the same number of characters allowed. So, a text field that is set to 50 characters isn't able to be assigned to one of 45.

 

[mithani]

Thanks Bob,

field size are exactly same. 50

thanks

mithani

 

[boblarson]

Then are you absolutely sure that it is Field Number 3 that you want and not 2?

 

[mithani]

Thanks Bob,

I want second field of combo box to be displayed. Is this code correct?

Me.address = Me.comSupplier(1)

Thanks

mithani

 

[boblarson]

Yes, that is correct.

 

[mithani]

Bob,

Even I made new form but still same problem. If you have time, can you try at your end?

Thanks

Mithani

 

[mithani]

Hi,

Can anyone help me with this. Why this command does not work.

Me.address = Me.comSupplier(1)

Even i tried msgbox me.comSupplier(1), shows error message "Type Mismatch".

Thanks for your help.

mithani

 

[boblarson]

Bob,

Even I made new form but still same problem. If you have time, can you try at your end?

Thanks

Mithani

You would need to post the db for me to do that.

 

[mithani]

Thanks Bob

Please see the attached file.

Thanks

mithani

 

[boblarson]

Okay, I think I found your problem. Somehow I missed the syntax. It should be:

(and I added the NZ to deal with null fields):

Me.Text6 = Nz(Me.Combo4.Column(2), "")
Me.Text8 = Nz(Me.Combo4.Column(3), "")

 

[mithani]

Thank you very much Bob.

Working great

mithani

 

[boblarson]

Glad to help mithani, as always. How are you coming along with things? Is it starting to gel better for you?

 

[mithani]

Hi bob,

Oh ya diffinately, I appreciate your help always.

thanks

mithani