I have a form frmAnalysisDetails. My switchboard has two entries. One that opens the form in Add mode and another that opens the form in Edit mode.
The option to open the form in Add mode seems to work fine, but the option to open the form in Edit mode, comes up in Add mode. I only see one record in the record navigator (a new blank record). I can add through the form, but then when the record is no longer visible (although it's there in the underlying table).
The form's RowSource is a single table.
I have checked the AllowAdditions, AllowDeletions, AllowEdits, etc. properties for the form and they are all set to Yes.
Does anyone have any ideas on what could be causing my problem? Any help would be greatly appreciate.
Thanks in advance
The option to open the form in Add mode seems to work fine, but the option to open the form in Edit mode, comes up in Add mode. I only see one record in the record navigator (a new blank record). I can add through the form, but then when the record is no longer visible (although it's there in the underlying table).
The form's RowSource is a single table.
I have checked the AllowAdditions, AllowDeletions, AllowEdits, etc. properties for the form and they are all set to Yes.
Does anyone have any ideas on what could be causing my problem? Any help would be greatly appreciate.
Thanks in advance