Click on subform record to open pop up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, i am not a programmer but a dabbler and batteling with the
following... I open a form that has a sub form on it indicating all the
previous requests. there is a comment field for each record on that i would
like to click on to open a pop up form with the full comment on... Could some
good soul please help with some code please...
 
Les,

You could always press Shift+F2.

....or use the following code:
Private Sub txtMyTextBox_DblClick()
RunCommand acCmdZoomBox
End Sub

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Hi Graham, it gives me an error message... I have the sub form within a
request form with a number of records on, i would like to click on a record
to see the all the comments.
I got a pop up form working and have a combo box so that i can select the
record to view, but when opened from the sub form click i cannot make a
selection ??
 
Les,

<<...it gives me an error message>>
What gives you an error message? What message?

RunCommand acCmdZoomBox works fine for me, but you could also try
DoCmd.RunCommand acCmdZoomBox.

Where did you put the code?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia


Les said:
Hi Graham, it gives me an error message... I have the sub form within a
request form with a number of records on, i would like to click on a
record
to see the all the comments.
I got a pop up form working and have a combo box so that i can select the
record to view, but when opened from the sub form click i cannot make a
selection ??
Click to expand...
 
Back
Top