Increase Link Criteria

[COB]

Does anybody know if it is possible to increase the link criteria between forms so that I can minimse my results??
Because my primary key has two fields Name and Date but I only seem to connect Name.
Thanks in advance.
COB

 

[Mile-O]

Does :

"[Name] = bla bla bla AND [Date] = #whenever#"

not work?

 

[COB]

What I've got is the following
I've got a list with a set of records which inclues "Term,Date,complete". Once you click on the list it opens a form showing that record but with one extra field "Term,Date,complete, Mail". When I tried to change the code to waht you suggested I got the following error "Type Mismatch".
Here is the code!!

stLinkCriteria = "[Term]=" & "'" & Me![ListOfQuaterlyReviews] & "'" And "[Date]=" & "'" & Me![ListOfQuaterlyReviews] & "'"

Any help is much appreciated..
Thanks a million.
COB

 

[Mile-O]

What information is held in [ListOfQuarterlyReviews]?

If they are dates you don't use the apostrophe, but the hash (#) sign.

 

[COB]

Hi
I replaces the(') with the (#) but it still gives out about a type mismatch..
Sorry for all the hassle.
COB

 

[Mile-O]

I've looked deeper into it and fixed it (I hope!)

stLinkCriteria = "[Term] = #" & Me![ListOfQuarterlyReviews] & "# And [Date] = #" & Me![ListOfQuarterlyReviews] & "#"


Also, are you aware that you have the control listed here as Quaterly when I think you might mean Quarterly?