ACCESS FEED: RE: [MS_AccessPros] Open Multiple Instances of a Form, each to a specific record

Kamis, 29 September 2011

RE: [MS_AccessPros] Open Multiple Instances of a Form, each to a specific record

Amy-

Because you open multiple copies be setting an object reference to the form's
class module, you can use that object to manipulate the form, including setting
the Filter and FilterOn properties or doing a search on the Recordset to move to
a specific record. Post the code you're using now with a more detailed
description of how you want to apply a search, and I can probably give you the
modifications you need.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of amy_hollows
Sent: Thursday, September 29, 2011 4:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Open Multiple Instances of a Form, each to a specific
record

I have used code from Allen Browne to successfully open multiple instances of a
form in my database (pretty sweet). Now, I would like to be able to open the
instances of this form to a specific record, which is specified in the search
results of another form that I created that searches a table based on 3
criteria. I can do these two things separately (open multiple instances, and
open a form to a specific record). Any ideas on how to combine these two ideas
into something work-able for me?

(P.S. I am now at the "cut and paste and modify and debug" stage of VB
programming so bear with me if my questions sound totally vague. I'm super
excited about programming and making this db work though, so any help is much
appreciated!)

thanks!

~Amy

------------------------------------

Yahoo! Groups Links