Master Child Relationship with Multiple Users

[Simplycongy]

Hi Everyone.

I have a form (fmMainScreen) with a number of Subforms.

fmMainScreen record source is tblMainScreen, which has two fields

ID - Autonumber
PC - Text

MainScreen only ever has one record the top one.

All of the subforms also contain a PC field, and are linked Master / Child in the correct way. With one user, this works great.

HOWEVER, when I've launched this out to multiple users, there seems to be a problem. When users make a change to the subform (e.g. fmComments), then the PC is not being entered in the new entry. I suspect this is becuase another user is entering a new PC.

Can anyone (a) understand what I mean and/or (b) point out what I'm doing wrong...

Thanks

SC

 

[Dennisk]

a) no don't quite understand. what fields(s) links the main and subform?