Display and Edit Subform record in the Main Form

[Icy]

Hello, I am trying to create a Access Form for Visitor Log. I have three
table, visitor table, sponsor talbe and Log table which contain both primary
ID for Visitor and Sponsor. The Main form have a combo box with all the
visitor name and the Log subform display visitor check in/out history. Now
what I want to achive is to be able to click on the Log subform's record and
have sponsor information appear on the Main form along with visitor
information and able to edit it and update the subform. Is there anyway this
could be done? Any help on this request would be appreciated, thanks.

 

[Bernie]

Hello, I am trying to create a Access Form for Visitor Log. I have three
table, visitor table, sponsor talbe and Log table which contain both primary
ID for Visitor and Sponsor. The Main form have a combo box with all the
visitor name and the Log subform display visitor check in/out history. Now
what I want to achive is to be able to click on the Log subform's record and
have sponsor information appear on the Main form along with visitor
information and able to edit it and update the subform. Is there anyway this
could be done? Any help on this request would be appreciated, thanks.

Use combo in the subform, create fields in the mainform and use recordsource
of combo results of subform for recordsource of the main form.

 

[Icy]

Thank you it works

Use combo in the subform, create fields in the mainform and use recordsource
of combo results of subform for recordsource of the main form.