Update single field from multiple rows

[dgaller]

I have a query with three columns Apparatus ID, Apparatus Type, Select. when I filter for Items true in select, I somehow want the result in the apperatus rows to populate an Engine field in an incident commanders form.

Example

Apparatus ID; Apparatus Type; Select
Engine 8............Engine ...............True
Engine 10...........Engine................ True


End up with a field that results in what is shown above.
Engine : (field in form)
Engine 8, Engine 10

 

[pbaldy]

You could adapt this technique to your needs:

http://www.mvps.org/access/modules/mdl0004.htm