Question with Double Click Macro - Access Developer Network


	Back to Access Developer Network Comments List

Upload Images @Reply Bookmark Link Email

Question with Double Click Macro

Jeff Shepard

4 months ago

I have an issue with the following Macro ""Where Condition."  It gives me an error.
See attach #1 #2.

Where Condition = {PassID=PassID

Can someone correct the Statement So upon double clicking the PassID field on my Continuous will go to the named form.  Now we had this conversation before.  My Brain is getting old and forgetful.

The first person that responds and has a Tip PayPal address gets $20.00 on the first of March 2025.  Put name in your response.  I will hunt down your PayPal address and pay you
I thank you for responding.

	Jeff Shepard OP @Reply 4 months ago

	Jeff Shepard OP @Reply 4 months ago

	Jeff Shepard OP @Reply 4 months ago
See Upload #1 and #2 for error and screen prints. Jeff

	Kevin Robertson @Reply 4 months ago
Remove the Curly Brace.

	Jeff Shepard OP @Reply 4 months ago
I correct the stmt. It now works. see attached.

	Jeff Shepard OP @Reply 4 months ago

	Kevin Robertson @Reply 4 months ago
Why is the first PassID also in quotes?

	Jeff Shepard OP @Reply 4 months ago
The problem I am having now is : I double click record #5. It gives me record #1. No matter what record I double click it gives record #1. So It changed. The first person that tells me what I need to add to the Macro to read the record chosen gets a tip. give me your name. Applies to the first person that responds.

	Jeff Shepard OP @Reply 4 months ago
Kevin I just uploaded a correction which I put in. See attached. Kevin you get the tip. It now works but only gives me record #1 not the record I choose.

	Jeff Shepard OP @Reply 4 months ago

	Jeff Shepard OP @Reply 4 months ago
Kevin, This is what I was able to find on how to write the stmt. So if you can tell me how to get it to read the record chosen. Currently it always reads record #1.

	Jeff Shepard OP @Reply 4 months ago
So Kevin the attached upload now works. Its only reading record 31 not the record choosen.

	Jeff Shepard OP @Reply 4 months ago

	Jeff Shepard OP @Reply 4 months ago
So Kevin, Where condition ==["PassID"]=[PassID] this works. Now I need to get it to Show the record chosen not record #1. This is the issue now. Can you solve it? I want to hire you for 2 more tips of $20.00. So pay attention for the next 8 hours. I will post the other issues in time. It is now 9:56am in Indiana. Give me till 7pm E.S.T. to post the issues.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Network.