Interesting Requery Problem AND solution

[Rod Makin]

Just thought that for once I could add to this forum and give something
back.

I had a problem where I was displaying a subform on one of my forms, the
data in the subform changed regularly which wasn't a problem as I used the
requery on the sub form. I 'optimised' the querys that the subform was
running on and changed things around and couldn't work out why my subform
would no longer refresh using requery as it had done before. It turns out
that the subform was based on a crosstab query, when I edited the query
(from within the report) I had to change this to a select query and simply
select the fields that I wanted (which is what I thought it was doing
anyway). Anyway, after changing it from a crosstab to a select query the
refresh worked again. Weird huh? Anyone know why?

 

[GaryS]

Rod,

sorry I can't answer your question about the elusive
refresh, but I have a question for you:

I have what sounds like a situation similar to yours:
FormA has a subform. If I go to FormB from FormA, FormB
adds a record to the table the subform is based on. I
would like that reflected on FormA's subform.

Question: At which event should I requery the subform;
and how do I refer to the subform?

Gary