Solved want open the specified record on double click please in search form (1 Viewer)

Local time
Today, 18:55
Joined
Oct 31, 2021
Messages
42
i trying to fix it from yesterday , last update its need to enter parameter value how i fix it please ?



321.jpg


1635768438316.png



1635768464917.png
 

Gasman

Enthusiastic Amateur
Local time
Today, 18:55
Joined
Sep 21, 2011
Messages
14,046
Looks like you might have got your concatenation wrong?
 

CJ_London

Super Moderator
Staff member
Local time
Today, 18:55
Joined
Feb 19, 2013
Messages
16,553
would help if you showed your code
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 02:55
Joined
May 7, 2009
Messages
19,169
DoCmd.OpenForm "ID Tickets", , , "INV='" & Me.INV & "'"
 
Local time
Today, 18:55
Joined
Oct 31, 2021
Messages
42
looks like INV is text in which case you need

"TKT.INV='" & Me.INV & "'"
😀Finaly work > thank you so much (y)(y)(y)(y)(y)(y)(y)(y)(y)

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

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

CJ_London

Super Moderator
Staff member
Local time
Today, 18:55
Joined
Feb 19, 2013
Messages
16,553

Users who are viewing this thread

Top Bottom