Subscript out of range - New front end form.

[Homegrownandy]

I've recently split my database, Now when I try to make a new form on the front end (this is where all the other forms I made before the split are kept), I get the error "subscript out of range".

*I do not get the error if I make a form for one table, only if I have information from multiple tables.


*I do not get the error making the form on the backend.
*I do not get the error on existing forms in the front end.

In a split database what's the standard procedure for making a new form?

Andy.

[Homegrownandy]

I have found a work around. It's not ideal but at least its working.

*Make the form on the back end
*copy the record source
*close backend
*make new blank form on front end
*paste record source.

It requires a bit more work setting up the forms this way but as I said, at least its working