how to refresh a query in subform

G

Guest

hi,
I have a form has a subform. the subfrom is based on query to calculate an
average values. in the subform there is a button to open another form which
is called employee grades form.
the problem is , when I open the employee grades which is for adding grades
for employee , the average values for all employees do not show unless close
the main for and reopen it .
I try to put a macro to refresh the sub form but dose not work.
can any body help me please.
 
R

Roger Carlson

I can't really tell from your question what's going on. However, on my
website (www.rogersaccesslibrary.com), is a small Access database sample
called "SubformReference.mdb" which illustrates how to reference a number of
things on subforms and subsubform, including requerying a subform. Perhaps
that will help

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
subform will not refresh 6
Counting multiple memberships 1
Subform Multiple Entries 1
How to refresh a single record in a datasheet subform? 1
Need help with a query 1
filter on subform looking at Week End date/prob navigate on main f 1
Form/subform worries 2007 1

Top