Requery, Output to table, Add Display in Form

[Guest]

Hi,
Is there a way to easily have a text box bound to a table, requery it and
and display table result? I lost on how to do this.

Thanks!

 

[Guest]

If you want to show the rows from a table in a form bound to another table
use a subform. You can then requery the subform control in the main parent
form's module.

If that's not what you want then post back with a more detailed description
of what's required.

Ken Sheridan
Stafford, England

 

[Guest]

I think that will work! I'll give it a try. I do have (1) subform added to
this form. Is there anything special I need to know with the adding the
second subform? Or, just do it like the first one?

Thanks!

 

[Guest]

Just add the second subform in the normal way. If the data in the table
which you want to show in the subform is independent of that in the main form
then you can leave the subform control's LinkMasterFields and LinkChildFields
properties blank; if you want to show rows which relate to the main form's
current record, e.g. all orders for the current customer, then you'd link the
subform and main form, in that case on CustomerID.

You can even have one subform showing rows related to the current row in
another subform if you wish.

Post back if you need any more advice on this.

Ken Sheridan
Stafford, England