Access

Moderators: None (Apply to moderate this forum)
Number of threads: 1075
Number of posts: 2224

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
Use Name Of Rectangle For Search Posted by msinsabaugh on 1 Apr 2010 at 9:35 AM
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.



 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.