[AccessD] JIT Forms

And in the end that is what I had to do, retrieve only one record.  That is
the superior solution for any large table. 


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: Thursday, November 08, 2007 11:40 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] JIT Forms

I'm good to go.  Thanks.  However, converting all the combos and subforms to
JIT still did not yield an acceptable opening time.  The reocrdsource for
the main form is retrieving all the records and the navigation buttons are
at the bottom of the form.  I have asked the client if users would really
use those buttons to move from one record to another.  I'm thinking not.  In
which case  retrieving one record might be the hot ticket.

Thanks and regards,

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, November 08, 2007 7:36 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] JIT Forms

And that is really about all there is to it.  Except...

You need to be careful about the Link Master / child properties.  I leave
them set and just change the source object IIRC.

Beyond that you need to make the decision whether to leave the subforms
bound or unbind them as the user clicks off the tab.  And no I don't do
anything about loading the combos specifically.  Since only the combos on
the specific subforms loading are at issue, this will not tend to be a
problem.

Since everyone else jumped in with info I will let you ask if you need more
than that.

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: Thursday, November 08, 2007 8:19 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] JIT Forms

Aha. That's what I was looking for. Change event.  Too bad there isn't a
GotFocus or Activate event for each page.  But this will work.   I can do a
Select Case on the page and load the controls for that page in the case for
each tab.  That will work!

Thanks

Rocky