Double click of listbox on a form (1 Viewer)

[moi]

Sirs,

Im using the below code to open a form from a listbox on a form.. this is working if one criteria only.

Can someone please add, if i have another criteria "propid" this is numeric control.. still learning to code, and i have no idea how to do it..

================================
Private Sub List104_DblClick(Cancel As Integer)

Dim strformName As String
Dim strCriteria As String

strformName = "frmPayment"
strCriteria = "[buyerID]= " & Me![List104]

DoCmd.OpenForm strformName, acNormal, , strCriteria
========================================

Any help would be appreciated..


Thank


End Sub
Any

 

[CJ_London]

try

strCriteria = "[buyerID]= " & Me![List104] & " AND Propid=" & me.propid

assumes propid is numeric

 

[moi]

try

strCriteria = "[buyerID]= " & Me![List104] & " AND Propid=" & me.propid

assumes propid is numeric

compile error: data member not found..

 

[CJ_London]

presume you have a control called 'propid' and not txtPropID or similar? and you have a field called propid in your form recordsource

 

[moi]

presume you have a control called 'propid' and not txtPropID or similar? and you have a field called propid in your form recordsource

Yes propid is in the recordsource...

SELECT [lstOnMain].[propID], [lstOnMain].[buyerID], [lstOnMain].[byrFName], [lstOnMain].[byrLName], [lstOnMain].[byrPhone], [lstOnMain].[byrStatus], [lstOnMain].[byrAgentID] FROM lstOnMain ORDER BY [propID];

 

[CJ_London]

and the answer to the first question is? and to be clear, I mean a control on the form you are using to open frmPayment

 

[moi]

and the answer to the first question is? and to be clear, I mean a control on the form you are using to open frmPayment

it is a listbox on a form where i launch the double click event, yes "propid" and buyerid are both there.

 

[CJ_London]

what is the revised code you are actually using? Your compile error implies it cannot find me.propid

 

[moi]

what is the revised code you are actually using? Your compile error implies it cannot find me.propid

the one you provided above..., strCriteria = "[buyerID]= " & Me![List104] & " AND Propid=" & me.propid

 

[CJ_London]

show two screenshots:

one of the form in design view and the data properties for the propid control

the second one with the form in normal view with controls populated and the error generated

 

[moi]

show two screenshots:

one of the form in design view and the data properties for the propid control

the second one with the form in normal view with controls populated and the error generated

Thanks a lot, i accidentaly removed the key control..