Refresh Form Update Query

[franklinbukoski]

I would like "due dates" to be automatically calculated/entered into a field
on a form after I input a "thru date" on the same form. How do I do this?

I created an update query that will update all records in a table whenever
it's run to recalculate due dates based on thru dates whenever I run the
query. However, while the form is open and a record modified the data does
not automatically populate after I enter a thru date. I tried placing the
query to run in the On Lost Focus field of the Thru Date properties, and the
query runs but the data does not visibly get updated. I have to close the
form, open the form, click back in the thru date and then click out of the
thru date for it to work.

 

[Allen Browne]

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article explains how to put the calcuated field into a query instead of
storing it in your table. That way Access automatically keeps it up to date
for you, and you never have to worry about whether it might be wrong in your
table. You can use the query anywhere you can use the table -- as the source
for a form, report, whatever.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...