using column 2 in unbound combo box to choose form

mary

Registered User.
Local time
Today, 21:49
Joined
Nov 14, 2000
Messages
37
I have searched the forum, but have not found any matches. I'm using an unbound combo box with the row source set by a query. That is working fine.

I'd like to use another field from that row to automatically open the correct form.

Bound column: idFormula
Column1:formula#
Column2:idPasteType

The combo box is shows the formula number, but I'm trying to write a macro based on the value in column2. Is this possible?

Any suggestions?

Thanks for your help!
mary
 
Use the following to refer to the value in column 2:
comboboxname.column(1)
 
Thanks for the suggestion. I tried it, but the error said" The object doesn't contain the automation object."

Any other suggestions?

Thanks again,

Mary
 
Never mind! I changed the column from 4 to 3 and it worked. Thank you for your help!!

Regards,
Mary :D
 

Users who are viewing this thread

Back
Top Bottom