Keep Subform record on the form after closing mainform

[accesswinston]

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

[twinnyfo]

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....

[accesswinston]

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.

[twinnyfo]

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.

[NeoPa]

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.

[Nauticalgent]

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.