I recently split a database I created a year ago - Got a accdb file and a accde file. This database has multiple forms where thru a search option the form is populated with data from a Main Table that's housed in the back end. The user then enters additional data to the sub form and thru macros both sections are appended to other tables. I've made copies of the front end (Named each front end differently)for the 4 users that are going to be entering data. The issue I'm having is that the first person in their front end is ok and can get to work. The 2nd and additional others will open their front end and the form is already populated and stuck with the data that's in the very first row of the Main Table. I've tried everything. I've even made multiple copies of the Main Table in the back end, named them differently and then linked one to each of the front ends under the "Main Table" name so that they're not all drawing data from the same table. Nothing works. What am I doing wrong. FYI - I'm not much on VB codes.