Command Button to Switch Between Subdatasheets

[bench]

Hi,

Very very new to Access, have some experience with excel vba but have learned most of this through the macro recorder, now i find out access doesn't have a macro recorder

My issue:

I have a database with contacts in (company name, address, phone number etc), each of these have three subdatasheets attached (i may be referring to this by the wrong name, i mean a related table), what i would like to do on my entry form is allow the user to click one of three command buttons that will then show the relevant subdatasheet (People, Postcodes, Instructions) I imagine this is really easy wondered if anyone could give me a kick start please.

Thanks



Ben

[pbaldy]

I think that so much of what one would want to do in Access does not lend itself to being "recorded" that having such functionality doesn't make sense. I think you'll find that the wizards will accomplish a similar goal for you.

To the point, I can think of a couple of potential solutions (both of which use forms based on your tables as subforms, not the tables themselves). The first is a little less efficient but maybe easier. You can put a tab control onto your form with 3 tabs. On each tab would be a subform based on the appropriate table. The user would click on the appropriate tab to see that data.

The second method would be to have one subform control on the form. Behind your buttons, you set the SourceObject property of that control to place the desired subform in there:

Me.SubformControlName.SourceObject = "FormName"

[bench]

To the point, I can think of a couple of potential solutions (both of which use forms based on your tables as subforms, not the tables themselves). The first is a little less efficient but maybe easier. You can put a tab control onto your form with 3 tabs. On each tab would be a subform based on the appropriate table. The user would click on the appropriate tab to see that data.

The second method would be to have one subform control on the form. Behind your buttons, you set the SourceObject property of that control to place the desired subform in there:

Me.SubformControlName.SourceObject = "FormName"

These both sound ideal options. I'm really new to all this so appreciate any further help you can give me.

For the second option you gave me i added a couple of command buttons right clicked on build event, build code then added in your code as above, replacing the "FormName" with my subforms name.

When i run it it errors highlighting ".subControlName" - Method or Data Name not found. I imagine i have to set this to an actual name in my own database(?) where would i find this?

ON THE TABS OPTION where and what would i put to command the change between subforms?

Really appreciate any help on this.

Thanks

[pbaldy]

Yes, that has to be the name of the subform control, which may or may not have the same name as the actual subform. If you go into design view of the form and click ONCE on the subform, you can go into the properties of the subform control (otherwise you'll be in the properties of the subform itself). That will tell you what its name is.

On the tabs option, no code would be required. You would put a different subform on each tab. The user clicking on each tab would be how they would view each subform.