I have a data entry form and subform (frmGENDataEntry - based on main tabl e with file information + frmGENClaimSubDE - based on sub table with additional information about file if it is strFType=Claim).
For lookup and editing purposes, I have a main form (frmGENREsults) which has a subform (frmGENClaimSub). My problem is that if there isn't any "claim information" entered when the file is first opened; then the subform doesn't display (just a grayed out square - the fields aren't visible at all) when I open the main form for lookup or editing purposes. At that time, if the strFType is Claim, I may be ready to enter information into the subform and into the subTable. If I change the file type to something else and then back again to Claim, then the form will display.
Relationship between the two tables is one-to-one.
I have this working in another database, but can't seem to see a difference between the two other than the relationship between those two tables is one-to-many.
Any ideas? I know it has to be something obvious, but I've been looking at it too long with the same eyes !
Thanks !
For lookup and editing purposes, I have a main form (frmGENREsults) which has a subform (frmGENClaimSub). My problem is that if there isn't any "claim information" entered when the file is first opened; then the subform doesn't display (just a grayed out square - the fields aren't visible at all) when I open the main form for lookup or editing purposes. At that time, if the strFType is Claim, I may be ready to enter information into the subform and into the subTable. If I change the file type to something else and then back again to Claim, then the form will display.
Relationship between the two tables is one-to-one.
I have this working in another database, but can't seem to see a difference between the two other than the relationship between those two tables is one-to-many.
Any ideas? I know it has to be something obvious, but I've been looking at it too long with the same eyes !
Thanks !