dynamic field name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I write
rsOrder! "[item" & intLoop & "]" = rsEquip![Item]

If I put
rsOrder![item1] = rsEquip![item]

it works fine but i want to loop round my reEquip recordset putting the data
into 5 fields item1, item2, item3 etc.

Anu suggestions please

Thanks
 
rsOrder("item" & intLoop= rsEquip![Item]
or
rsOrder.Fields("Item" & inLoop) = ...
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top