when splitting tables, wizard says "subscript out of range"

While reviewing my table structure, the Wizard suggested I split off certain
information into a separate table. After doing that, I tried to procede to
Next and got the "subscript out of range" message.

Thanks
--
Chip

Here's Microsoft's page on what to do when the wizards don't work:
http://support.microsoft.com/?id=303769

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Chipster" wrote in message
...
While reviewing my table structure, the Wizard suggested I split off
certain
information into a separate table. After doing that, I tried to procede to
Next and got the "subscript out of range" message.

Thanks
--
Chip

In addition to Allen's suggestion, try Compacting the mdb & re-running the
wizard. "Subscript out of Range" issues *could* be the result of a lot of
changed/deleted fields (or other things) taking up space that compacting
might cure. Sort of a long shot, but won't hurt to try.

HTH,

"Chipster" wrote in message
...
While reviewing my table structure, the Wizard suggested I split off
certain
information into a separate table. After doing that, I tried to procede to
Next and got the "subscript out of range" message.

Thanks
--
Chip