Hi- I have a form that used to work just fine but I must have dropped it on its head recently while I was tinkering in my db and now I just cant seem to fix it!
Form: Documents
based on: a query that pulls together three tables: documents, people, and links. (people and documents have a many-to-many relationship and links is the table that links them)
form documents shows no records in it even when no filter is applied, AND EVEN WHEN THE UNDERLYING QUERY SHOWS 346 records. yikes!!! I am going nuts trying to get those to show up on the form....
.... because the form is opened from another form "people" with a button labeled "show documents for this person", the button then opens the documents form with vba code filtering it to show documents related to the person. It shows nothing when opened that way and it shows nothing when it is opened on its own (when it should show all records)...
IS THERE SOMETHING REALLY SIMPLE THAT I'M MISSING???!!! I'd appreciate any help=
Thanks,
Andy
Form: Documents
based on: a query that pulls together three tables: documents, people, and links. (people and documents have a many-to-many relationship and links is the table that links them)
form documents shows no records in it even when no filter is applied, AND EVEN WHEN THE UNDERLYING QUERY SHOWS 346 records. yikes!!! I am going nuts trying to get those to show up on the form....
.... because the form is opened from another form "people" with a button labeled "show documents for this person", the button then opens the documents form with vba code filtering it to show documents related to the person. It shows nothing when opened that way and it shows nothing when it is opened on its own (when it should show all records)...
IS THERE SOMETHING REALLY SIMPLE THAT I'M MISSING???!!! I'd appreciate any help=
Thanks,
Andy