473,322 Members | 1,352 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Navigating between form and subform on separate tabs

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.

Thanks.
Jul 26 '07 #1
3 1917
Rabbit
12,516 Expert Mod 8TB
Ok, so what have you tried so far and what problems are you having?
Jul 26 '07 #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
Rabbit
12,516 Expert Mod 8TB
To get from a subform to a parent form you use Me.Parent.ControlName.SetFocus
Jul 26 '07 #4

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

Similar topics

2
by: Neil Shapiro | last post by:
I have a form with a subform whose record sources are two different queries. I want to see if I can replace this with a form with two tabs, putting the form results from the first query on the...
4
by: Mike MacSween | last post by:
It's a form, with (so far) 4 tab pages on it, each of which holds 2/3/4 subforms. (I like tabbed forms by the way - do we all?) Basically the subforms are different ways of looking at the...
0
by: misscrf | last post by:
I am currently working on a database, in 3rd normal form, which is for candidates who apply for a job with the law firm that I workd for. My issue is with good form design. I have a main...
5
by: tdmailbox | last post by:
I have a form with a child form. In the child form there is a list of names that can grow quite large. On the parent form I want to display the first name from the child form. I set up a test...
2
by: musicloverlch | last post by:
Here is the situation: I have a main form with lots of tabs. The first tab has a subform with a lot of tabs. Each of those tabs has 1 subform. That subform contains an ID. So subsubform1 has...
1
by: dBNovice | last post by:
Please help! I have 3 forms: Task, Subtask, Elements. Elements is a subform of Subtask and Subtask is a subform of Task. I am able to navigate from Task to Subform to Element and from Element to...
3
by: ApexData | last post by:
I'm starting a new project. A Personnel System. I have considered opening a single bound form to the main employee table. The user can scroll the records to any individual. I would like to have a...
4
by: QntmPg | last post by:
Hi all I am trying to design a database that holds contact/demographic information on a person and what studies they have participated in. I have a few ideas, but wanted to get feedback on...
4
by: Harlequin | last post by:
I have a question concerning the need to trigger events within a "child" subform which is itself enbedded within a master "parent" form and which is accessible via a tab in the parent form. Becuase...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.