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

Keep Subform record on the form after closing mainform

P: 2
Hi all,

I have a Mainform and a subform, and a subsubform.

The purpose is to allow people to enter information on the forms and can edit it when the form is re-opened.

My problem is, when I close the mainform and reopen it, the subform is blank.

Since, my subform has a subsubform under tab control, it is a single form.

How can I keep the subform records when re-opening the mainform?

thanks

Attached Images
File Type: jpg question.jpg (31.2 KB, 171 views)
Jun 25 '18 #1
Share this Question
Share on Google+
5 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,284
accesswinston,

Welcome to Bytes!

It sounds more like the problem is with the Parent-Child relationship between the forms. If this is set properly, whatever record the main form has on it, the related records in the subforms will be displayed. This is the typical structure for Main-Subforms.

Is this how your forms are set up?

Your questions isn't exactly clear, either, because you don't mention what record the user is supposed to go to when the main for opens....
Jun 25 '18 #2

P: 2
Let's say,
the mainform contains Address and Job_ID.
the subform contains Equipment and Equipment_ID.
the subsubform contains Consummables and Labour.
The user is supposed to input multiple consummables and labours for each Equipment; and multiple Equipments for one Job.

It works well when the mainform is open. But if the user re-open the form, all contents in the subform are blank.
Jun 25 '18 #3

twinnyfo
Expert Mod 2.5K+
P: 3,284
However, you haven't really said anything that you haven't already said.

If you have your forms built with a proper Parent-Child relationships whenever you navigate your main form to the Job_ID, the Equipment and consummables should display. And you have not answered my question as to whether these relationships are built.

Unless you want to get extremely and unecessarily complicated, forms are not typically designed to open to a person's most recent record. It can certainly open to the last record of a record set or the record most recently modified (which, again, requires some more complexification).

However, based on what you have said thus far, the forms are behaving as expected.
Jun 25 '18 #4

NeoPa
Expert Mod 15k+
P: 31,489
Hi Winston.

In a way what Twinny's saying is we can't tell where you've gone wrong if you don't give any indication as to what you've done, or tried to do.

We know you've done something wrong. We can't hope to identify what that might be when we have no information as to anything you've done.

Does that make sense.
Jun 25 '18 #5

Nauticalgent
P: 92
Sounds like either the tables relationships are flawed, the parent/child links on the forms are not set up properly or both.

But without more input from the OP, this is speculation at best.
Jun 26 '18 #6

Post your reply

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