Synchronize the subform to the main form

[tjones]

Attached is a pared down version of my database to the form causing the problems. Open the database and select Course Work.

I have a form that uses a subform. I need to be able to synchronie the two so a selection in the subform loads that record to the main form for editing. View attachment studentinfoSUBFORMsm.accdb

As I am a newbie at access please make instructions detailed enough I can follow.

This form began as a split form (the synchronization works great there) but with a cascading combo box series a split form is very unstable and drops the display of information until no information is displayed even though it is in the table. I have also tried a list box but could not get it to display only the records associated with the one person instead of all records.

Once this form works this database is finished. Thanks.

 

[John Big Booty]

Perhaps this link will help or even this video.

 

[delikedi]

I battled with what I think is the same problem, recently. Take a look at http://www.access-programmers.co.uk/forums/showthread.php?t=236690
You can get the result you want but it is against the nature of the subform object to behave as a record selector for the main form. You will face the same weird behavior I faced. You can use implement the code to suit your needs, lines 40 to 60 do the synchronisation.