datasheet - question 9 - datasheet as a subform
Posted on 2009-04-22
I have a datasheet as a subform, that is not connected by a key to the parent form.
On the parent form on have a control called: Notes
When the entire form open, the datasheet is displayed AND the Notes field is HIDDEN.
b) I would like:
when user clicks on a row in a datasheet,
to SHOW the Notes field with additional info for that row.
c) I created an event for the Subform's detail section: click event
Private Sub Detail_Click()
Me!txtName.Visible = True
Me!lblNotes.Visible = True
Me!txtNotes.Visible = True
d) I set a breakpoint in the above event, BUT the event is not firing when I click on a row
in the datasheet.
Any advice, pls, tx, sandra