I am trying to create a recordset of data that is picked up from an xml page eg. a load of addresses. The end result is that if there is more than one address - show the addresses as choices in a drop down box. That when chosen will populate all the other address fields.
I have got as far as being able to store each field of the address (place the last record of the set brought back into the fields on the form) in a variable that then must be written to a 'table' or 'recordset' on the fly before the code loops to the next address. What would be the most efficient way of temporarily holding this data. This request for addresses will be made in a 100 user enviroment so I do not want Access to put on weight!!! As is it's wont.
Any direction would be helpful