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