Need the code for...

[pwicr]

I'm trying to create a dblclick event that will open the "supplier" form but to the one that is currently on screen.

My weakness is creating codes.

Thanks.

 

[pbaldy]

Like this?

http://www.baldyweb.com/wherecondition.htm

 

[pwicr]

I'm almost there...

Private Sub PrimeVend_DblClick(Cancel As Integer)

DoCmd.OpenForm "Suppliers", , , "SupplierName ='" & Me.OnDblClick & "'"

End Sub

and it opens to a blank "supplier".

what am i missing to get it to open to the supplier that is displayed in my product form?

 

[pbaldy]

OnDblClick is the name of a control that has a supplier name in it? Doesn't sound like it.

 

[pwicr]

sigh...blonde moment.

Thanks pbaldy!!!!! Works great!

 

[pbaldy]

Happy to help!