How to link main form with Sub Form

[mdavid]

Hi,
I want to add a subform after the main form has been created - not create it together with the main form.
I need help linking the form to the subform so that the subform is updated when the main form moves to another record, at the moment all fields on the main form are updated when a new record is selected, but the subform continues to display the results of the initial query.
How can I get the subform to be updated together with the main form?
Thanks for any help.
David

[pbaldy]

The subform control on the main form has master/child link properties. Those would refer to the field(s) that join them. If you add a subform with the wizard, it will ask about them.

[mdavid]

Hi pbaldy, thanks for your reply.
I've filled those Data Property fields, but there's no change on the subform - still displays only initial query results.
Any other ideas?

Thanks
David

[pbaldy]

Can you attach the db here?

[mdavid]

Hi Paul, When I clicked the 3 horizontal dots for Link Child Fields I get the message "can't link unbound forms" even though the main form has a record source and the subform has a source object - are these bound forms?
On the subform in "Link Master Fields" I entered the textbox name that contains the main form's link field and now the subform is updated together with the main form.
The link master field name in the table is "Species ID", is the space a problem?

[mdavid]

Excuse my ignorance - how do I "attach the db"?

My accdb file is 10 Mg

[ArviLaanemets]

Where you did place your subform? Into Main form, or into some other form both your "main" and subform are inserted into? When the last, and you want to keep this design, then you must have unbound control(s) in this 3rd form, which is/are updated by OnCurrent event of your "main" form, and you have to link your subform to this/those unbound control(s) manually (Access will protest, that it is not possible, but don't trust him about this).

[mdavid]

My form and subform are now in sync - when I select a record on the main form the subform is updated. Problem now is clicking anywhere on the subform or trying any form action (save, close ect.) on the main form I get "Index or primary key cannot contain a null value".

Here's the Main Form Property Sheet:


Attachment 30875Attachment 30876Attachment 30877Attachment 30878


Here's the subform data properties:

Attachment 30879

[mdavid]

Main Form Property Sheet:







And here's the subform Data Property sheet:





At this point I don't want to change any data it should all be read only.

Thanks
David

[pbaldy]

If you compact/repair the db and then zip, it may be small enough to attach. If not you can email it to me.

[mdavid]

Hi, I emailed my db as requested, and now received a reply saying "Please post your reply on the forum, thanks" pointing me back here .
Did you receive my db? What do I need to do? Where can I see Paul's reply?

[mdavid]

For anyone that's interested, I solved the error message: "Index or primary key cannot contain a Null value" with the following code:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Undo
End Sub

This form is read only.

Now the other major problem is that scrollbars and record navigation doesn't work on the subforms.

Really like to hear from anyone that knows how to fix this.

Thanks
David

[pbaldy]

No, I didn't get it. Sounds like you sent it to the forum. Try

pbaldy
gmail
com

That code will prevent you from making any changes to the data.

[mdavid]

OK I've sent it to you.
Also scrollbars, and navigation buttons (next, last etc) on the subforms are not working - but I can scroll vertically with the mouse wheel.

[pbaldy]

Got it, but I'm away from a computer for a day or two.