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

Navigating between form and subform on separate tabs

P: 2
I have a form and a subform on two separate pages in a tab.

I would like that when the user finishes inserting the information in the subform, he will get to a combo box in the bottom of the subform and will have two options to choose from:
1. Add another record to the subform.
2. Return to the parent form in the current parent record.

The options will be executed by a command next to the combo.

Jul 26 '07 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,366
Ok, so what have you tried so far and what problems are you having?
Jul 26 '07 #2

P: 2
I'm new to these things, so I don't quite know how to make the connection between the combo box, the command, and the actions I want them to do.

I know, of course, how to create the combo and the command, but I don't know which code they should execute.

It would be great if you guys could give me a lead on this.

If this can be acheived through just two command buttons instead of the combo box values it would also be great. I know how to create a command button which takes you to a new record in the subform, but I don't quite know how to create a command button in the subform which takes you to the parent form.
Jul 26 '07 #3

Expert Mod 10K+
P: 12,366
To get from a subform to a parent form you use Me.Parent.ControlName.SetFocus
Jul 26 '07 #4

Post your reply

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