Prev: Lookup fields referring to tbls w/o relationship
Next: Report
From: Barry A&P on 8 Jan 2010 22:19
Terry
this post is on my unanswered list, so i figured i would check on it.. Tou
mentioned a concern about speed with a bunch of subforms.. Check out the TAB
control and put each subject or subform on a different tab that way access
doesnt even open the sub unless you click the tab. so you can have 15 tabs
and subforms while only using as much processor as required to display the
active tab..

Barry

"MTSmith" wrote:

> Barry,
> You were right. I finally realized that I should just make a second main
> form and put the 2nd subform on the bottom of it, and not put 2 subforms on
> the same main form. It works beautifully and I've finally finished making
> the database using that system. Thanks for the hint.
>
> "Barry A&P" wrote:
>
> > Terry
> > Maybe you should use a bound subform "Events" on your main "clients form"
> > and link child and master on ClientID and dont deal with all that macro
> > stuff..
> > Just my two cents.
> > Barry
> >
> > "MTSmith" wrote:
> >
> > > I also forgot to add that I had put in a couple of events directly into the
> > > events table with the ClientID# just to see if I could get the events form to
> > > open up according to the Client record I had on screen. On the Events button
> > > on the client record I used the macro Open Form where [ClientID]=Forms![main
> > > client record]!FAMID . It didn't open the events form showing the records I
> > > had put in manually for that client. Is there something wrong on my syntax?
> > >
> > > "MTSmith" wrote:
> > >
> > > > I have a client record that when I push the events button I want a Events
> > > > Form to open up and automatically set the ClientID# so they can start
> > > > entering data. I read about the setvalue you can use in a macro, but I
> > > > cannot find the setvalue operation in the macro builder. The ex: is in the
> > > > help like this:
> > > >
> > > > Echo Echo On: No Stop screen updating while the macro is running.
> > > > Close Object Type: Form
> > > > Object Name: Product List
> > > >
> > > > Save: No
> > > > Close the Product List form.
> > > > OpenForm Form Name: Products
> > > > View: Form
> > > >
> > > > Data Mode: Add
> > > >
> > > > Window Mode: Normal
> > > > Open the Products form.
> > > > SetValue Item: [Forms]![Products]![SupplierID]
> > > > Expression: SupplierID
> > > > Set the SupplierID control to the current supplier on the Suppliers form.
> > > > GoToControl Control Name: CategoryID Go to the CategoryID control.
> > > >
> > > > in the macro builder I choose Action of Open Form and I choose the Events
> > > > form. On the next line I open the box, but setvalue is not a choice. Am I
> > > > doing this wrong? Any help? Thanks in advance.
> > > >
> > > > Terry Smith
> > > >
 | 
Pages: 1
Prev: Lookup fields referring to tbls w/o relationship
Next: Report