Populating a field within a subform for each record by using a but

[Guest]

I have a form with a subform on it. When the user clicks a button, I need it
to populate a field on the subform for each record in the subform. I am
using a foreign key for the subform which is equal to the primary key on the
form. I can get it to work on the first record in the subform using a DO
WHILE or IF statement, but it will not advance to the next record. Can
anyone help me or have any suggestions?

 

[Larry Daugherty]

You need to post back with details on your tables and fields involved
and the query for your subform. Also you must be explicit in what you
want to happen. Right now I'd interpret it as: you want one field in
each record in the subform control to be populated with something
about the subfomr record(s).

HTH