I have a subform that is independent of its parent form except for the fact that it is displayed in it. The subform shows records based on an underlying query. It does display records according to the query. The user can click on the record selects of the subform and thereby change the current record.

I now need to access the subform from the parent form to determine which record (CurrentRecord) the user has clicked on so that I can retrieve data for use in a recordset based on a table.

I have tried a variety of methods to no avail. Any advice on this subject will be greatly appreciated!

Are you referencing the subform fields correctly?

Forms!YourMainFormName!YourSumformName.Form!YourSu bformFieldName