Uber noob question about manually built split form

[darkthorn]

Since the split forms can't be used on a navigation form I am trying to manually build a split form and the appearance is great, but I cannot find how to link the subform to the main form for record navigation. I am sure it's really something stupid that I'm missing, but for the life of me I can't figure out what it is.



Thanks for anyone that can help this short bus inclined person.

[June7]

Set Master/Child link properties of the subform container control.

Both forms have the same RecordSource? You want to allow editing in both? Not sure this will work. Think will produce RecordLock conflicts.

[darkthorn]

Set Master/Child link properties of the subform container control.

Both forms have the same RecordSource? You want to allow editing in both? Not sure this will work. Think will produce RecordLock conflicts.

Thanks for the reply.

Both have the same recordsource, which is a table. It's about as basic of a mapping as I can make, when I try to set the parent and child links the datasheet only displays the currently selected record of the main form.

What I'm trying to do is display the datasheet in the sub form and have the matching row data displayed in the form controls, just like in a split form.

[darkthorn]

Thanks for the reply.

Both have the same recordsource, which is a table. It's about as basic of a mapping as I can make, when I try to set the parent and child links the datasheet only displays the currently selected record of the main form.

What I'm trying to do is display the datasheet in the sub form and have the matching row data displayed in the form controls, just like in a split form.

Whoops, forgot to answer one of your questions, no, I don't want editing in both, I want the row selection to be done in datasheet but all editing done in the form.

[June7]

Yes, because both have same recordsource and the link is the uniqueID, Master/Child linking is not relevant.

What you want is to have user select record in subform (set properties AllowEdits, AllowDeletions, AllowAdditions to no) and mainform go to the selected record. I have never seen anyone try this. Usually, a choice is made in an unbound combobox and then code will filter or move to record meeting the criteria.