Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Use Name Of Rectangle For Search
I am using Access 2007 and I've looked everywhere I can think of to find an asnwer for this but to no avail. I have a form with a lot of rectangles on it. I want to display data based on which rectangle is clicked by the user. It seems to me as if the easiest way is to have the key field of the database contain the name of a rectangle (Box100, Box101, Box102...). As an example I have the rectangle name hard coded in (Box414 in this instance) but I would like to have the event get the name of the rectangle clicked and use that as the search criteria
DoCmd.OpenForm "DataEntry", , , "ID='Box414'"
Where "DataEntry" is the name of a data entry form
and "ID='Box414" is what I want to replace with the name of the rectangle.
I hope this makes sense. If someone can direct me where to look I would sure appreciate it.