Records not showing

  • Thread starter Thread starter TimH
  • Start date Start date
T

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
 
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
Click to expand...

By correcting the error in your code, or in the form's recordsource.
For help doing so post the code and the recordsource.
 
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#
 
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#
Click to expand...

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?
 
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 said:
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#
Click to expand...

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?
Click to expand...
 
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 said:
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 said:
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#
Click to expand...

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?
Click to expand...
Click to expand...
 
Back
Top