Ali Edwards
Registered User.
- Local time
- Today, 20:49
- Joined
- Apr 19, 2001
- Messages
- 68
I have a macro which opens a qery in Datasheet view, selects the first record, copies it then pastes it into an unbound text box in a form. Then another macro runs instructing it to go to the next record in the query, copy and paste it into the same form, after the first record, inserting a comma between each record. This macro repeats and all works well but when it gets to the end of the recordset in the query it warns "Can't go to specified record" (because it has come to the end of the list)followed by three 'Halt' type messages. The form does complete so the job is done but how do I make a condition that will stop the macro when it gets to the end of the recordset so that I don't get all the warning messages? As the size of the recordset changes I can't give the macro a predefined repeat count.
Greatly appreciate any help with this.....
Greatly appreciate any help with this.....