[AccessD] JIT Forms

I think so.  What I do is set one of my 

fltr "ClientID", someClientID

and then place fltr("ClientID") in the ClientID field (where) of the source
query for the form to cause the form to filter down to a single record.


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Friday, November 09, 2007 12:56 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] JIT Forms

Unfortunately, in my case.  MOST of the bound fields are not in subforms but
scattered throughout the multiple tabs.

I think we're going for the one record or very few records  approach by
modifying the Record Source on the fly rather than using form filters as it
is now.  Hopefully that reduces what's coming over the wire.

Brings up another question - if a filter is set on Open, do all the records
come over anyway and access just makes the filtered subset available to the
form?

Rocky