Very Strange subform data entry issue

[RayMilhon]

I have a form with several subforms in a tab control. One of them when a new record is entered and the tab is changed to a different subform and then returned to the first subform No data shows and the status on the bottom says the record was deleted by another user. The DB is in development and I am the only person with Access to this DB. Then if the main form record is changed and then go back to that same record the data is there. Any idea why that is happening?

[June7]

Would need to know more about data structure and relationships and form/subform settings. But it sounds like subforms are bound to same dataset.

If you want to provide db, follow instructions at bottom of my post.

[RayMilhon]

Also the Data is in SQL Server 2008 and the front end is MS Access 2010. The form in question is based on a table that links member data to the Advertisements table and only has the fields customerID and Adv_ID. There are 2 combo boxes based on the Advertisement table 1 for the Advertisement (type of Ad) and 1 for the date of Ad. Table structure is

Customer
CustomerID
name
address
city
state
zip
phone
dob

Advertisements
ADV_ID
ADV_Type (Adv_Type could be Newspaper, Radio, Facebook, Ad Works, Google)
ADV_Source (for example if ADV_Type is Newspaper there are 4 different newspapers that could contain that ad, Radio has 3 different local stations)

AdvDate
ADVDateID
ADVID
AdV_Date

Finally is a linking table that links customers to Advertisements

[CJ_London]

sounds like you have two (or more) subforms each working with the same records. So make a change in one and it affects the others - so you are the other user.