Refreshing record source

  • Thread starter Thread starter Joan
  • Start date Start date
J

Joan

Hi,
I have a form in which the record source query contains a table made from
a Make-Table query. How do I get my record source refreshed upon opening the
form? If I need to execute the Make-Table query first where do I do this?
Any help is so appreciated.

Joan
 
Joan,

Not totally clear... what do you mean by "refresh"? Re-run the make-table
query before you open the form? If that's the question, then the answer is
don't open the form directly. Instead, write a simple two-action macro that
runs the make-table query first, and then opens the form (actions:
OpenQuery, OpenForm) and run the query (directly or by means of a button on
a form). You could also use a few simple lines of VBA code instead of a
macro.

YET... I strongly urge you to reconsider the need for a table. If your
make-table query can access the data, then why not just change the
make-table query to a plain select query, and use that as the recordsource
for your form? The advantages are (a) no duplication of stored data and (b)
no need for refreshing, macros or code.

HTH,
Nikos
 
Back
Top