Solved want open the specified record on double click please in search form

[ahmedrashed3210]

i trying to fix it from yesterday , last update its need to enter parameter value how i fix it please ?

 

[Gasman]

Looks like you might have got your concatenation wrong?

 

[CJ_London]

would help if you showed your code

 

[ahmedrashed3210]

would help if you showed your code

Private Sub INV_DblClick(Cancel As Integer)
DoCmd.OpenForm "ID Tickets", , , "TKT.INV=" & Me.INV
End Sub

 

[ahmedrashed3210]

would help if you showed your code

 

[ahmedrashed3210]

Looks like you might have got your concatenation wrong?

how i can fix it !

 

[arnelgp]

DoCmd.OpenForm "ID Tickets", , , "INV='" & Me.INV & "'"

 

[CJ_London]

looks like INV is text in which case you need

"TKT.INV='" & Me.INV & "'"

 

[ahmedrashed3210]

looks like INV is text in which case you need

"TKT.INV='" & Me.INV & "'"

Finaly work > thank you so much

DoCmd.OpenForm "ID Tickets", , , "TKT.INV='" & Me.INV & "'"

can i add DoCmd.maxmuiz after above code to make it full screen !

 

[ahmedrashed3210]

Thank you so much guys
I appreciate this a lot

 

[CJ_London]

can i add DoCmd.maxmuiz after above code to make it full screen !

need to be clearer - your db is set up using tabbed documents according to post #19, in which case you need to maximise the access window - see this link https://dba.stackexchange.com/questions/57653/vba-maximize-access-application-main-window

But if your form is a popup you would maximise the popup - which you can do with docmd.maximise in the form open event