Records not showing

[TimH]

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

 

[John W. Vinson/MVP]

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.

 

[TimH]

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#

 

[John W. Vinson/MVP]

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?

 

[TimH]

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

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?

 

[TimH]

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

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

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?