Search results

Thanks for your reply Dan, I put the following code in the On Enter event and it did not make a difference: Forms!frmAlumni!fsubAlumniCommittees!strAlumniCommittee.Requery Thanks again, Dan

Thanks Pat, Jon and Donna for all your help. That did the trick. Dan

Thanks Jon and Pat for the replies. I'm new to Access so my problem now is where or how do you join the 3 many-side queries to the Events table? Is it done through Queries, Tables or Relationships? Thanks, Dan

I have a macro setup on On Double Click in a subform on a tab control to a Combo Box called Services to allow the user to add records if a Service is not included in the Combo Box. Combo Box on the subform is setup as follows: Name-strAlumniServiceID Control Source-strAlumniServiceID Row...

I have 4 files that have a 1-many relationship. The 1-side of the relationship is a file called Events with the primary key being Event ID and Event Date. There are 3 files in the many relationship. Event Contributions: Event ID, Event Date, Contribution ID, Contribution Amount. Event...

Thanks Chris, your example did the trick. My problem was there are so many names and properties, I could not find the subform properties. Thanks again, Dan

Chris, I put the code in the main form, in the On Open event using Code Builder. When the code executes I get a Compile Error: Method or data member not found. Help says it is Error 461. It stops on fsubAlumniServices. If I delete fsubAlumniServices from the code, it stops on...

Thanks for the reply Chris. That should do the trick, my only other question is where to put the code. Would it go on the On Change Event in the Tab Control with Code Builder or something on the individual tab Pages? Thanks, Dan

I have a form with 4 tabs that contain 4 subforms. I would like each subform to start in the same spot on the tab. Is there any way to force this or lock the starting position of the subform on the tab control? Everytime I try to get the subforms aligned, one of the other subforms moves up or...