Change form record based on List Box

[Matt Pierringer]

Well I realize this has to be really easy, I am just skipping right
over it.

What I have is my form called: frmMain
My unbound list box "lstNames" that has two columns "AdjusterName" and
the other is "ID"
I want to find the record that matches the "ID" so its
Me.lstNames.Column(1)

What do I do to change the record in vb on the double click event?

Thanks for your time and input,
Matt P

 

[Al Campagna]

Matt,
On my website, under Tips, I have a 97 and 2003 sample file called Combo
Quick Find. It demonstrates how to select a name from a combo (or list),
and go to that record.
My combo columns are ID and FullName, with ID hidden.
The user selects a FullName, and the combo displays the FullName, but I
really store the ID field in the bound combobox. I then Find Record... the
appropriate record for that ID.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Matt P]

Matt,
    On my website, under Tips, I have a 97 and 2003 sample file called Combo
Quick Find.  It demonstrates how to select a name from a combo (or list),
and go to that record.
    My combo columns are ID and FullName, with ID hidden.
    The user selects a FullName, and the combo displays the FullName,but I
really store the ID field in the bound combobox.  I then Find Record...the
appropriate record for that ID.

--
    hth
    Al Campagna
    Microsoft Access MVP
   http://home.comcast.net/~cccsolutions/index.html

    "Find a job that you love... and you'll never work a day in your life."









- Show quoted text -

Ahh thanks Al! So simple yet works perfectly. Thanks so much!