I'm stuck on issues with two different DB's at work, but I've split them into two posts so no one gets a headache trying to read one huge post. The other will be in the Access: Reports Section
For this one, I'm trying to create a Data Access Page. I've created it based upon a query which involves three linked tables A B and C. Results include all of records from A but only matching records from B and C. When going through the wizard it asked me to pick one table to update I just chose table A.
My problem is, when I view the page, the first record displays, but my record navigation buttons are "greyed out." I've checked every property that I can find and the ones that sould control it are set correctly. Is this problem due to the multiple tables in the query that Page is based upon? I've stared at this for way too long.
Any thoughts?
For this one, I'm trying to create a Data Access Page. I've created it based upon a query which involves three linked tables A B and C. Results include all of records from A but only matching records from B and C. When going through the wizard it asked me to pick one table to update I just chose table A.
My problem is, when I view the page, the first record displays, but my record navigation buttons are "greyed out." I've checked every property that I can find and the ones that sould control it are set correctly. Is this problem due to the multiple tables in the query that Page is based upon? I've stared at this for way too long.
Any thoughts?