subform and main form relationship

[AOGFADUGBA]

Hi All
can i get main form to display the selected record in the sub form. They are both linked to the same table. sub form is used to filter the records in the table and its a continuous form. The main form is a single form which i want to use to edit any record selected in subform
Table name is cedisCashBook
Mainform is EditCedisPaymentVoucher
subform is CedisCashBookEdit subform
they are linked by the PVNO index field
thanks

 

[HiTechCoach]

What version of Access are you using?

If Access 2007 or later then I recommend using he new SPlit form feature to automatically handle this:

Create a split form (Click Here)

A split form is a new feature in Microsoft Office Access 2007 that gives you two views of your data at the same time — a Form view and a Datasheet view. The two views are connected to the same data source and are synchronized with each other at all times. Selecting a field in one part of the form selects the same field in the other part of the form. You can add, edit, or delete data from either part (provided the record source is updateable and you have not configured the form to prevent these actions).

Working with split forms gives you the benefits of both types of forms in a single form. For example, you can use the datasheet portion of the form to quickly locate a record, and then use the form portion to view or edit the record. The form portion can serve as an attractive and functional header for the datasheet portion. This technique is used in many of the template databases that are available for Office Access 2007.

 

[AOGFADUGBA]

What version of Access are you using?

If Access 2007 or later then I recommend using he new SPlit form feature to automatically handle this:

Create a split form (Click Here)

Thanks so much. I think that is the way to go. Did it initially, just looking for other options to make the software look better.

 

[AOGFADUGBA]

Thanks