Using ListBox selection in new form

[GrahameG]

Hi all,

I used to think I knew a little bit about Access but my brain has gone walkabout on this one! I have a Listbox in one form which holds a sub-set of a table based on a variable SQL statement. When the user selects a value from the listbox I want to take the bound column (Primary Key) value and open a new form with the entire table record in that form.

I have actually done this before but no longer remember how (senility is such a bummer) or have access to my old databases.

Would greatly appreciate any help on this.

 

[rbowes]

If the new form is bound how about this:

Dim lngKey as long

lngkey = me!listbox.Columns(boundcolumn)

docmd.openform "MyNewform",,, "[Key] = " & lngkey

Give it a try, it should work.

Bob