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, 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

 

[SydneyGeek]

Do you mean subdatasheets when you browse the table, or subforms on a main form?

Subdatasheets are not a good idea, nor is directly working with tables. You should instead create a form based on the main table, then create forms (in datasheet view) for the 3 related tables.

You then have several options. They include:

1. Add a Tab control and drag each subform onto a different tab. Switching between them is just a matter of clicking the appropriate tab

2. Make all 3 subforms exactly the same size, overlay them, and use button(s) to display the desired one

3. Only have one subform on the main form, and use code to switch the source object (ie, load a different subform).

1 is the easiest to set up, 3 gives the best performance.

Denis

 

[SydneyGeek]

You may find this article useful; came across it today while browsing another site.
http://vb123.com.au/toolbox/00_Docs/subdatasheetsplus.htm

Denis