I have a main form with 2 subforms (using a tab control to display the subforms - I hope that's the right translation as I use the French version of access). Anyway, the relationships for the underlying tables are:
MainForm_Table -> SubForm1_Table (always 1 to many)
SubForm2_Table -> MainForm_Table (doesn't always exist and yes the relationship is this way round; the SubForm2-Table key is an autonumber field but the link is another field which not a key for either table)
There is no problem with the first Form-Subform but the second is giving me a headache.
When I enter data in the first field of this subform, I get a message saying:
(Hope my translation is correct)
Impossible to assign a value to this object because
1 Form may be open in read-only mode or
2 Form may open in Create mode or
3 Value too big for field
None of these is the case.
I suspect it's the fact that the underlying tables' relationship is "the wrong way round".
Any thoughts? I'd like to keep the layout as it's more intuitive for the users.
Many thanks
MainForm_Table -> SubForm1_Table (always 1 to many)
SubForm2_Table -> MainForm_Table (doesn't always exist and yes the relationship is this way round; the SubForm2-Table key is an autonumber field but the link is another field which not a key for either table)
There is no problem with the first Form-Subform but the second is giving me a headache.
When I enter data in the first field of this subform, I get a message saying:
(Hope my translation is correct)
Impossible to assign a value to this object because
1 Form may be open in read-only mode or
2 Form may open in Create mode or
3 Value too big for field
None of these is the case.
I suspect it's the fact that the underlying tables' relationship is "the wrong way round".
Any thoughts? I'd like to keep the layout as it's more intuitive for the users.
Many thanks