Read specific records from table using VBA

[dar149]

Hi,
I have a main form that populates a subform. Each record on the subform opens a linked form, which when filled out ends up with a result, stating whether the form that is complete and another result stating if the form is accepted or rejected. I get both results and store them in a table, which shows up as a datasheet subform.

The parent/child link between the main and subform is Sample#. What is need to do is, based on the Sample# in the main form, check to see if all records are completed and accepted in the subform (which is it's own table). Is there a way to do this?

Thanks,
Debbie

 

[dar149]

Or could I possibly read the results of a query from VBA???

 

[dar149]

Just to give a little more detail: I can get each record in the subform to come up with either an Accept or Reject. But when I update the field on the Main form, the value is overwritten each time a record in the subform is updated. Is there another way to capture all the values on the subform and evaluate to either an Accept or Reject for the field on the Main form?

Thanks...

 

[dar149]

Does anyone have any other ideas as to how to capture this value? I've tried many different things, but nothing to date has worked and we are unable to roll out this database until I have a solution.