Help please add amount to query field on form

[hullstorage]

I have a query that brings up a selected amount of records

so when i select a customer the query brings up the records for that customer

then i have a field a the top of the query form called order that i want the value of this added to the Ref fields of the query so it would be like this

after i select customer these records will be shown from query

Date From To Ref
01/10/08 Hull Leeds
02/10/08 Manchester Hull
03/10/08 Hull London

I then want the content of field at top of form to be entered into the ref fields

order field= 1005
so would end up with this

Date From To Ref
01/10/08 Hull Leeds 1005
02/10/08 Manchester Hull 1005
03/10/08 Hull London 1005

I have tried me.ref=me.order but as i say this only updates the first record

any ideas