New User, Set Focus & Coded Requery

[Guest]

I am fairly new to access, so a thorough response would be very much
appreciated.

Layout of the database: 1 master table, from which make-able queries were
run in order to group desired information sets. Reports were built upon
these "make-table" tables. I have oneform which is sourced to my master
table. 2 questions.

1. I would like to be able to re-run the make table queries from a command
button on my form. The goal is to be able to enter and edit data, then print
the corresponding updated reports, all from a switchboard. I am not very
familiar with writing code and do not know which option i should use to build
my expression. Is there a way to write in code to re-run these queries upon
closing the form and just scratch the command button altogether? I noticed
you could build an expression to execute upon closing the form.

2. I want for focus to remain on a combo box, and do not know which of the
areas i should enter my experssion into, or how to enter the expression. If
anyone could give a fairly brief explanation of the code that would be great.

 

[tina]

if you can use a query to pull the appropriate records to dump into a new
table, why bother with the new table? just use the query as the source for
your report; it's quicker, cleaner, and reduces database bloat.

hth

 

[Guest]

I figured out the first part of my message, still need help on the second
though.