By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,933 Members | 1,223 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,933 IT Pros & Developers. It's quick & easy.

Order form in access

P: 24
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
Jun 14 '07 #1
Share this Question
Share on Google+
5 Replies


P: 24
I think i should add that a subform in a subform is what could be a solution, is this possible?
Jun 14 '07 #2

P: 24
Panic averted, I have managed to put a subform within a subform. Still, I am curious about tabs
Jun 14 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jun 16 '07 #4

P: 24
That works!

Thanks!
Jun 16 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
That works!

Thanks!
You're welcome
Jun 16 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.