thanks and you're welcome. Really just one statement though ... better to use CurrentDb.Execute "Queryname" to run the query, and then no need to change SetWarnings (or Echo). Cool tip! These DataPig videos by Mike show how flexible Access is -- and more are coming :)
Hi Mr I create two forms(form1&form2) which are found on a third main form (form3 have no record source) when an event occurred on form 1 an appened query will be run and so new records appened on table2 of form 2 but the appened new records are not visible on form2 because both forms are already opened on form 3. How can I make visible without closing and opening forms. That is, how can I auto refresh form 2?
Really it's great, recordset with 3 lines code, thanks so much for making Access awesome.
thanks and you're welcome. Really just one statement though ... better to use CurrentDb.Execute "Queryname" to run the query, and then no need to change SetWarnings (or Echo). Cool tip! These DataPig videos by Mike show how flexible Access is -- and more are coming :)
Hi Mr
I create two forms(form1&form2) which are found on a third main form (form3 have no record source) when an event occurred on form 1 an appened query will be run and so new records appened on table2 of form 2 but the appened new records are not visible on form2 because both forms are already opened on form 3. How can I make visible without closing and opening forms. That is, how can I auto refresh form 2?
Any news on the video how to do this via code and not using queries? 😊