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.