Steven_Bash
Registered User.
- Local time
- Today, 06:57
- Joined
- May 9, 2018
- Messages
- 27
Hey ya'll!
So i have multiple tables,queries, and forms, in this form i search a record, then edit it on this recordsource table. then i have this editquery that has that recordsource table and "allthedata" table jointing and getting the "allthedata" table to update(edit) its record/data with recordsource table data. Before that I have this append query which appends one record to the "allthedata" table each time this editquery runs. The issue is before any edits, the "allthedata" table has that appended record but once i edit any record, it blanks out that record on the "allthedata" table... please help? like whats causing that & solution. im thinking it has to do with the editquery when it runs but i dont know exactly what. Thanks
So i have multiple tables,queries, and forms, in this form i search a record, then edit it on this recordsource table. then i have this editquery that has that recordsource table and "allthedata" table jointing and getting the "allthedata" table to update(edit) its record/data with recordsource table data. Before that I have this append query which appends one record to the "allthedata" table each time this editquery runs. The issue is before any edits, the "allthedata" table has that appended record but once i edit any record, it blanks out that record on the "allthedata" table... please help? like whats causing that & solution. im thinking it has to do with the editquery when it runs but i dont know exactly what. Thanks