View Single Post
  #1  
Old February 17th, 2010, 04:16 PM posted to microsoft.public.access.forms
Humbled Learner
external usenet poster
 
Posts: 36
Default Update Subform Query

Hi

I have a form called Adit. It contains general information (text boxes).
The operator would add information and close the form. Say you add 3 lines.

I have a form called Review. It contains general information and a [date
closed] text box. An operator would open the Review form, view a subform
which contained data (3 lines mentioned above) from the Audit Query. The
audit query is based on a "null" closed date.

So, I want to open the Review form, choose a line from the subform, say line
2, add a closed date (in the review form) and have the audit subform refresh
to only show lines 1 and 3, again based on a null [closed date] value.



Thank You