Allen Browne's search form

[Guest]

I have created a search form using Allen Browne's where string solution
http://allenbrowne.com/ser-62.html

Does anyone know how I can change the form to be able to click on one of the
results and open another form (my input form) at this particular record.
Could it be done on a double click of the record.

 

[Allen Browne]

Use the DblClick event procdure of whichever control you want (or several if
you like.)

It will involve OpenForm, with a WhereCondition. For example, if you have a
numeric field named ID, and you want to open Form2:
DoCmd.OpenForm "Form2", WhereCondition:= "ID = " & Nz(Me.[ID],0)

(This won't work if Form2 is already open.)

 

[Guest]

Thans Allen but struggling to get this to work, I input the criteria into my
search and it returns say 5 results in the Detail section, you then get the
arrow record selector that you can move down each record on the left, how can
I double click on this arrow to select that one record on the other form, I
don't know where to pout your code (which double click)

Use the DblClick event procdure of whichever control you want (or several if
you like.)

It will involve OpenForm, with a WhereCondition. For example, if you have a
numeric field named ID, and you want to open Form2:
DoCmd.OpenForm "Form2", WhereCondition:= "ID = " & Nz(Me.[ID],0)

(This won't work if Form2 is already open.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have created a search form using Allen Browne's where string solution
http://allenbrowne.com/ser-62.html

Does anyone know how I can change the form to be able to click on one of
the
results and open another form (my input form) at this particular record.
Could it be done on a double click of the record.

 

[Allen Browne]

Use the DblClick event procedure of the *form* if you want it to respond to
double-clicking the Record Selector.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thans Allen but struggling to get this to work, I input the criteria into
my
search and it returns say 5 results in the Detail section, you then get
the
arrow record selector that you can move down each record on the left, how
can
I double click on this arrow to select that one record on the other form,
I
don't know where to pout your code (which double click)

Use the DblClick event procdure of whichever control you want (or several
if
you like.)

It will involve OpenForm, with a WhereCondition. For example, if you have
a
numeric field named ID, and you want to open Form2:
DoCmd.OpenForm "Form2", WhereCondition:= "ID = " & Nz(Me.[ID],0)

(This won't work if Form2 is already open.)

I have created a search form using Allen Browne's where string solution
http://allenbrowne.com/ser-62.html

Does anyone know how I can change the form to be able to click on one
of
the
results and open another form (my input form) at this particular
record.
Could it be done on a double click of the record.