Open A Record from a ListBox in Another Form

[malik via AccessMonster.com]

Hi
I have a form name FrmDrVoucher. In this form i have a Button Name BtnOpen.
by pressing this a new form opens with a listBox which have all the
DrVouchers save by this form.
Now plz tell me that how can I open a record in th form DrVoucher by Dbl
Click.


Thank you

 

[theDBguy]

Hi,

Does the listbox include the primary key. If so, in the DoubleClk event, you
could try something like:

DoCmd.OpenForm "FormName", , , "[PrimaryKeyFieldName]=" & Me.ListboxName

The above assumes that the Bound Column is the primary key.

Hope that helps...