UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Open A Details Form Based On Two Criteria    
 
   
josephbupe
post Jul 2 2011, 12:56 AM
Post #1

UtterAccess Guru
Posts: 721
From: Lusaka,Zambia
Hi,

I need help to open a details form based on two criteria.

What I have is a form with a treeview control desplaying a hierrachy relationship between parent nodes (Persons Names) and child nodes (Offences).

Selecting an Offence under a particular person reveals some offence's details on the other side of the form where I now wan't to include a button to opend a pop up form linked to that particular offence (PersonOffenceID)

Initially, the following would only open a form based on one criterial (PersonsID); so I what to include in it another criteria for PersonOffenceID

CODE
stLinkCriteria = "[PersonID]=" & Me![PersonID]


I will appreciate your help.

josephbupe
Go to the top of the page
 
+
Doug Steele
post Jul 2 2011, 03:46 AM
Post #2

UtterAccess VIP
Posts: 17,607
From: Don Mills, ON (Canada)
CODE
stLinkCriteria = "[PersonID]=" & Me![PersonID] & " AND [PersonOffenceID] = " & Me![PersonOffenceID]
Go to the top of the page
 
+
josephbupe
post Jul 2 2011, 04:53 AM
Post #3

UtterAccess Guru
Posts: 721
From: Lusaka,Zambia
Thank you Doug.

It worked very well.

Warm regards.
Go to the top of the page
 
+
« Next Oldest · Access Q and A · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 03:38 AM