John,
Thanks. That worked.
Jose
John Viescas <[EMAIL PROTECTED]> wrote:
Jose-
You should use the Primary Key value for the filter:
DoCmd.OpenForm "frmCallDetails", _
WhereCondition:="[Call Received] = #" & _
Me.[Call Received] & "#"
I'm assuming Call Received is a date/time value.
John Viescas, author
"Building Microsoft Access Applications"
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Jose Luis Jr Mora Jr
Sent: Thursday, December 01, 2005 5:22 PM
To: [email protected]
Subject: [ms_access] Filtering a form
Hi everyone,
I have a rather simple dilemma but for some reason I cannot get this to
work. Can someone help me out?
I am creating a database for a crisis hotline where people call-in if they
are feeling depressed, need someone to talk to, etc. In the database, I am
tracking basic information -- date/time the person calls, the identity they
choose to reveal to the hotline, medication the person may be taking, etc.
One of the other things that needs to be tracked is each phone call that
is received by the hotline. It is possible to receive multiple phone call
by the same person as well as only receiving one call per person. The
dilemma that I am having is that I have the basic information of the person
on a main form and call history in a subform. I am trying to setup a macro
where if I double-click on one of the call history entries a 2nd form open
with a more detailed view of the call. I have the following setup:
Basic Information
----------------------------------
Client ID ---- Primary key
Call history table
-------------------------------------
Call received ---> Primary
Client ID ---> Foreign Key
I am trying to filter for all entries where Client ID (foreign key)
matches Client ID (primary key) in a macro. I have also tried to do this
with the 2nd form which is open by the filtering option.
Any ideas?
[Non-text portions of this message have been removed]
Yahoo! Groups Links
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "ms_access" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
