Pop up

[Guest]

is there any way that when i'm in my query i can double click on a record and
a form pop up. i'd like to be able to do this so that i can see the notes
fields more easily.(i have up to 3 dependant on the query/form)

i've looked in the design area of the forms and can see rows that say "on
double click" and "pop up"

can this be done?
am i looking in the right place?
do i need to build a macro or an expression?

 

[Rick B]

Not in a query, no. You could use code to maybe do this in a form.
Personally, I use a continues form with a small button next to the record
that will open another form and filter for the appropriate record.

 

[SusanV]

Hi Katie,

You can easily do this in VBA. I have a similar form for searching where
users can select a customer by name or company or job code or... well,
several fields. The form which opens, frmContracts, is filtered on the data
in field they double clicked on. For the JobCode field, for example, I used
this code in the Double Click event:

Private Sub fldJobCode_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmContracts", , , "fldJobCode = '" & Me.fldJobCode.Value &
"'"
End Sub