Main Form Sub Form Data does not populate to query

[Flashqueen]

Thank you - this forum is very helpful.



Issue 1: A main form that shows current data from another table. A sub form to enter data. I want the sub form data to populate the recordsource query of the main data. The form is split so that I can see the records. The data only populates when I click the next record.

Issue 2: a: The data may populate to another record -
b: The data may not populate at all -

Issue 3: I cannot save the record at all. On the main form it is grayed out. On the sub form the option to save is there, but it will not save to the record showing on the form.

Please help - blue is issue 2 and red is issue 3. The diary table that the form is based on will not have data in it until it is put in by the user. This is because they may not need to add a diary.

Am I making things too complicated?

Thank you.

[June7]

Is this a form/subform or a Split form?

"I want the sub form data to populate the recordsource query of the main data." does not make sense to me.

Data is committed to table when form is closed, move to another record, or run code to save.

[Flashqueen]

Thank you for the prompt reply. It is a split form/subform. (The subform property is set to a single form.)

[Missinglinq]

...I want the sub form data to populate the recordsource query of the main data." does not make sense to me...

Makes no sense to me, either, and you haven't explained it. Main Form should populate one Table, and the Subform should populate another, related Table.

Linq ;0)>

[June7]

A Split form is not a form/subform. A Split form is a special type of form. After looking at your image again, it does appear to be a Split form. Yes, edits in datasheet section will not be reflected in other section until move to another record. Edits in other section are reflected in the datasheet after exiting the control.

After edit in datasheet section, Refresh the form. Unfortunately, this will set focus on the first record.

That's the way Split form works. I've never used it.

[Flashqueen]

True. Very true. Main form is already populated. (Think the light bulb may have came on.) Subform should populate and then have it all appear in the query. Will check.

[June7]

Our confusion comes from your reference to form and subform. There is NO subform. The Split form shows the same data in two sections, but it's all the same source.

[Flashqueen]

Yep, looks like no subform. There are two sources. Main form (2013...query) sub form (diary table). Need to come together (diary query).



When the user clicks save they see the updated data below.

[June7]

Don't know your data relationships.

If you have two tables in the form RecordSource, then what you really need is a form/subform, not a Split form. See post 4.

Why would DiaryDate be in both tables?

[Flashqueen]

One is a hearing date and the other a diary date for follow-up. At this time let's consider this close and I'll do only form/subform and see where it gets me. The thing is it was working earlier and I decided to do some cosmetic changes and now the problem. Will let you know if I've fixed, revamped, or gave up.

Thanks everyone for your valuable input - have a great day.

[June7]

Your image shows arrow linking two DiaryDate controls, not the HearingDate field.

Good Luck.