Order form in access

[hlebforprimeminister]

Hi

I am creating a purchase order form in access. I have to create a single form to enter the information into 3 different tables (let's call X, Y, Z).

Each of these tables has an autonumber primary key. Information can be entered into table X without entries in Y or Z.

However, table Y requires the primary key of X AND table Z requires a primary key entry from Y.

I have tried using a form and subform, but this only allows entry into tables X and Y. Is there any way to get data entry into 3 related tables on the same form?

Also does anyone know how the visualbasic that i can use for a button to move to the next tab in a tabbed form? As the button wizard doesn't have this option

[hlebforprimeminister]

I think i should add that a subform in a subform is what could be a solution, is this possible?

[hlebforprimeminister]

Panic averted, I have managed to put a subform within a subform. Still, I am curious about tabs

[MMcCarthy]

Each tab in a tabbed form has it's own identity.

Usually they are identified as Page numbers e.g. Page1, Page2, etc.

The following should work. A command button on Page1 to move to Page2 would be ...

Me.Page2.SetFocus

[hlebforprimeminister]

That works!

Thanks!

[MMcCarthy]

That works!

Thanks!

You're welcome