Help having button find an assigned location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm needing help on how to have a button use what value i have in my combo
box, and find the hyperlink assigned to that value and open it. Here is how
I have things set out.

I have a combo box on my form linked to a table with two colums. 1. is Base
Rate and 2. is Location. What i'm wanting the button i have on the form to
do is look at what Base Rate is selected in the combo box, and then find the
Location assigned to that base rate and open it.

Any Ideas? Thanks in advance!
 
Is location another table? Your Combobox.column(0) is the Base Rate and
combobox.column(1) is the location, correct?
So in the after update event of the combobox, you will have the location by
reading column(1).

Try this in after update:
debug.print me.yourcomboboxname.column(1)

Now, if you are opening another form (??) you would probably want to pass
that value to the new opened form with openargs. Read about that in the VB
Help section.

Damon
 
Yes, the location is another table, and you are correct about the columns
being 0 Base Rate, and 1 being Location, one question i have now, is that i'm
not wanting to print the location. I'm needing it to open the hyperlink,
which is actually a program.
Can i just substitute something into
debug.print me.yourcomboboxname.column(1)

that would open that program?

Another question is do i only have to put it into the after update slot of
the combo box?
Thanks for the help.
 
Back
Top