Records not showing

The code is:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmDate"
stLinkCriteria = "[ID]=" & Me![ID]

DoCmd.OpenForm stDocName, , , stLinkCriteria

and the recordsource for the form is tblDate; filter is [ID] = 1 as the
record opened was record 1; and when i change to different date id the filter
changes, however it does not display all records associated with [ID] = id#
--
timH


"John W. Vinson/MVP" wrote:

> On Thu, 24 Jul 2008 12:55:01 -0700, TimH
> <kujtimh RemoveThis @discussions.microsoft.com> wrote:
>
> >I have a form Linked to another by code; when second form oppens only one of
> >many recods assiosiated with the link show and On form properties I have
> >show All records, and on filter the link is indicated; how do I solve this?
> >
> >thanks in advance
>
> By correcting the error in your code, or in the form's recordsource.
> For help doing so post the code and the recordsource.
>
> --
>
> John W. Vinson/MVP
>

On Thu, 24 Jul 2008 19:10:02 -0700, TimH
<kujtimh DeleteThis @discussions.microsoft.com> wrote:

>The code is:
>
>Dim stDocName As String
>Dim stLinkCriteria As String
>
> stDocName = "frmDate"
> stLinkCriteria = "[ID]=" & Me![ID]
>
> DoCmd.OpenForm stDocName, , , stLinkCriteria
>
>and the recordsource for the form is tblDate; filter is [ID] = 1 as the
>record opened was record 1; and when i change to different date id the filter
>changes, however it does not display all records associated with [ID] = id#

What DOES it display? What is the Recordsource property of the form?
What is the datatype of ID? Is it a <uck> Lookup field? Does the table
in fact have multiple records for the selected ID?

--

John W. Vinson/MVP

Thank you for your time and patients
It displays only one set of data,
Form property Record source is ...tblDate
Data type is number// It is not a ,uck. Lookup Field // and the table does
in fact have multiple records but only the first one shows then it moves to
new record...
again i want to thank you for your patients in educating me.
--
timH


"John W. Vinson/MVP" wrote:

> On Thu, 24 Jul 2008 19:10:02 -0700, TimH
> <kujtimh.DeleteThis@discussions.microsoft.com> wrote:
>
> >The code is:
> >
> >Dim stDocName As String
> >Dim stLinkCriteria As String
> >
> > stDocName = "frmDate"
> > stLinkCriteria = "[ID]=" & Me![ID]
> >
> > DoCmd.OpenForm stDocName, , , stLinkCriteria
> >
> >and the recordsource for the form is tblDate; filter is [ID] = 1 as the
> >record opened was record 1; and when i change to different date id the filter
> >changes, however it does not display all records associated with [ID] = id#
>
> What DOES it display? What is the Recordsource property of the form?
> What is the datatype of ID? Is it a <uck> Lookup field? Does the table
> in fact have multiple records for the selected ID?
>
> --
>
> John W. Vinson/MVP
>

I was trying to double check all the links and in Table-Vie of my
demographics i came across something. I noticed that my demographics ID were
blank but a + sign was present and when I clicked on it it asked to link to a
table. A drop box with all the tables; once I clicked on the tblDate,
switched to forms, went through my forms to the date form in Form view it
showed the records and I was able to scroll throu the different records.
Thanks John for encouraging me to look.
--
timH


"TimH" wrote:

> Thank you for your time and patients
> It displays only one set of data,
> Form property Record source is ...tblDate
> Data type is number// It is not a ,uck. Lookup Field // and the table does
> in fact have multiple records but only the first one shows then it moves to
> new record...
> again i want to thank you for your patients in educating me.
> --
> timH
>
>
> "John W. Vinson/MVP" wrote:
>
> > On Thu, 24 Jul 2008 19:10:02 -0700, TimH
> > <kujtimh.DeleteThis@discussions.microsoft.com> wrote:
> >
> > >The code is:
> > >
> > >Dim stDocName As String
> > >Dim stLinkCriteria As String
> > >
> > > stDocName = "frmDate"
> > > stLinkCriteria = "[ID]=" & Me![ID]
> > >
> > > DoCmd.OpenForm stDocName, , , stLinkCriteria
> > >
> > >and the recordsource for the form is tblDate; filter is [ID] = 1 as the
> > >record opened was record 1; and when i change to different date id the filter
> > >changes, however it does not display all records associated with [ID] = id#
> >
> > What DOES it display? What is the Recordsource property of the form?
> > What is the datatype of ID? Is it a <uck> Lookup field? Does the table
> > in fact have multiple records for the selected ID?
> >
> > --
> >
> > John W. Vinson/MVP
> >