Selecting a particular record - Help

[Ed Powell]

I'm trying to open a new form on one record that is
determined by a double-click on the record selector in the
subform of another record. I have no problem opening a
subform from a mainform combo box and selecting records by
one of the combo box catagories, or selecting one record
from a unique choice in the combo box, but trying to open
a separate form on the same single record as one that was
double-clicked in the subform. (Sheeez, I just re-read
this and I don't even understand it, will try again)
1. Have a main form with an embedded subform. A combo box
labeled "program" has several programs as choices.
2. After update on the combo box fills in the subform with
all the necessary information on all the items from the
program that was selected in the combo box. (A list of all
records in that program)
3. Want to pick one record and double-click on the left
side record selector and open up another form that has
every field for that one record availabe for view or edit.
4. The ability to double-click and open the new form is
dependent on the security level of the user. (That part's
not important to this question, it was stated to give a
reason why I wanted to open the form).

 

[Guest]

I perform a similar operation by creating a separate form
to display the data in the record and then setting the
double-click event for a field on the subform to:

Private Sub Primary_DblClick(Cancel As Integer)
DoCmd.OpenForm "frm-Equipment", , , "[EqIndex] = " &
[EQIndex]
End Sub

"Primary" is the field on the subform that is double-
clicked, "frm-Equipment" is the separate form that shows
the data for one equipment record, and "EqIndex" is the
primary index for the table.

 

[Guest]

Thanks, I had solved the problem in a similar manner but
by using a query on the full database as the control
source and then putting a "like" statement in the query on
one of the fields. Works great so far but haven't stressed
it from all sides yet to see if it holds up. I appreciate
the response.