How To Update Split Form's Record Source From A Remote Database

[deepaktheindian]

Hi Guy's,

I'd made an Access database with some userforms attached in a single file of accdb extension. Now I'm trying to split my database because I want to keep datasource and userforms on seperate locations.
To do this I've made a copy of my original file and seperated it, now I've got a seperated datasource file on a different location, then I've deleted all the tables and queries from the copy of my original database, I've assigned the new location of datasource everywhere in the database, where I've to open database.
But now it's not working.. I'm getting error message "The Expression On.." on every event that I've created/used in my application E.g. on click, on open, on mouse over.. and the Split forms that I've created are also not showing the details..

Can someone help me to solve this issue..??
If it's not the right way to split a database then how can I do it??

I've to split my database to keep datasource and userforms on different locations, and also I've to update RecordSource property of the split forms to show details..

Thanks