Multiple filters on form

[MOGSY]

Hi. I've created a form that returns records based on multiple filters (using
http://allenbrowne.com/ser-62.html). I would like to be able to double click
on a result and a new form (which the user can edit the record) opens. How
can I do this?

Thanks.

 

[Chegu Tom]

Probably

in the double click event of a textbox
-----------------
dim stDocName, stLinkCriteria as string

stLinkCriteria = "[recordid in new form]=" & [me].[thecontrol containing
that id data on your form] & " "
stDocName="the name of your new form)
DoCmd.OpenForm stDocName, , , stLinkCriteria
-------------

If the recordid is string type then add some single quotes

stLinkCriteria = "[recordid in new form]='" & [me].[thecontrol containing
the id data] & "'"

 

[Chegu Tom]

With multiple filters you may need some ANDs or ORs in the stLinkCriteria

Probably

in the double click event of a textbox
-----------------
dim stDocName, stLinkCriteria as string

stLinkCriteria = "[recordid in new form]=" & [me].[thecontrol containing
that id data on your form] & " "
stDocName="the name of your new form)
DoCmd.OpenForm stDocName, , , stLinkCriteria
-------------

If the recordid is string type then add some single quotes

stLinkCriteria = "[recordid in new form]='" & [me].[thecontrol containing
the id data] & "'"

Hi. I've created a form that returns records based on multiple filters
(using
http://allenbrowne.com/ser-62.html). I would like to be able to double
click
on a result and a new form (which the user can edit the record) opens.
How
can I do this?

Thanks.

 

[MOGSY via AccessMonster.com]

Thanks. I'll try this.

With multiple filters you may need some ANDs or ORs in the stLinkCriteria

Probably

[quoted text clipped - 22 lines]

 

[John W. Vinson]

Thanks. I'll try this.

With multiple filters you may need some ANDs or ORs in the stLinkCriteria

Probably

[quoted text clipped - 22 lines]

Thanks.

Just bear in mind: stLinkCriteria needs to be a valid SQL query WHERE clause,
without the word WHERE. It can be as complex as you wish, with subqueries,
calculated expressions, etc.

It may be helpful to create a Query in the query grid that displays the data
you want, and use View... SQL to see how Access constructs the WHERE clause.
You can then use this as a model for your stLinkCriteria.