0. I have 2 tables Stuff and Contracts.
1. I have Query that joins 2 tables.
It creates a table where there is added info about contracts only to those stuff members who have open contracts.
The query is like this:
2. I have Form1 (a spreadsheet) with Query as a source. Form1 is open.
3. I open Form2 that runs a VBA script that makes a change to the table Stuff: It takes data about a stuff member and move to another line of the table (copy to another line and then clear from the previous line).
4. I expect Form1 to be updated automatically, but it happens in weird way if a stuff member has an open contract. I see doubled data.
And I have to click the Refresh All button to get Form1 updated.
The question is, how to make Form1 to be updated automatically in this case?
-------------------------------------------------------
If I change the source of Form1 to table Stuff instead of Query, then I can get an autoupdate on the table changes.
I don't get how the queries work in this part. Why joined lines don't auto-update?
1. I have Query that joins 2 tables.
It creates a table where there is added info about contracts only to those stuff members who have open contracts.
The query is like this:
SQL:
SELECT Stuff.*,
contracts.term,
contracts.date_start,
contracts.date_off,
contracts.etc
FROM Stuff
LEFT JOIN contracts
ON Stuff.member_id = contracts.member_id
WHERE ((contracts.date_off > Date()) Or IsNull(contracts.date_off))
ORDER BY Stuff.prior_num;
2. I have Form1 (a spreadsheet) with Query as a source. Form1 is open.
3. I open Form2 that runs a VBA script that makes a change to the table Stuff: It takes data about a stuff member and move to another line of the table (copy to another line and then clear from the previous line).
4. I expect Form1 to be updated automatically, but it happens in weird way if a stuff member has an open contract. I see doubled data.
And I have to click the Refresh All button to get Form1 updated.
The question is, how to make Form1 to be updated automatically in this case?
-------------------------------------------------------
If I change the source of Form1 to table Stuff instead of Query, then I can get an autoupdate on the table changes.
I don't get how the queries work in this part. Why joined lines don't auto-update?