p_d_hodgson
New member
- Local time
- Today, 04:07
- Joined
- Jul 15, 2020
- Messages
- 11
Hi,
Hopefully @AccessJunkie will pick this up, or someone who knows what this error means. I am getting this error in a very simple situation. I have am using Access 365 and two main forms and one subform:
The first form (Form1) shows details from table A and has a subform showing showing the related data in table B. The form has two buttons which have macros to open the second form (originally just simple macros, but now converted to VBA).
The second form (Form2) only has the fields of table A, two of which are disabled (the pk field, and a date field which is the creation date of the record having a default value "=Date()"). No macros exist on Form2 (I have checked, re-checked and re-re-checked every control in the form on the Events table of the properties).
The buttons on Form1 are for "New" (opens Form2 in acFormAdd), and "Modify" (opens Form2 with the currently displayed item from table A) in acDialog mode.
The error occurs when pressing "New"... Form2 displays an empty form except for the ID field (which says "New") and the creation date field (which shows the current date). If I enter data up to and including the last data entry field, then Tab, or press the Close [X] button, I get the error. Pressing [OK] will (for Tab) refresh Form2 for a new record, or for [X] will close the form and return to Form1. In both cases the data is saved.
I am really stuck... Why is this happening? What do I have to do to eliminate this error? Or, is there a way to just suppress this message?
Many thanks in advance,
Paul
Hopefully @AccessJunkie will pick this up, or someone who knows what this error means. I am getting this error in a very simple situation. I have am using Access 365 and two main forms and one subform:
The first form (Form1) shows details from table A and has a subform showing showing the related data in table B. The form has two buttons which have macros to open the second form (originally just simple macros, but now converted to VBA).
The second form (Form2) only has the fields of table A, two of which are disabled (the pk field, and a date field which is the creation date of the record having a default value "=Date()"). No macros exist on Form2 (I have checked, re-checked and re-re-checked every control in the form on the Events table of the properties).
The buttons on Form1 are for "New" (opens Form2 in acFormAdd), and "Modify" (opens Form2 with the currently displayed item from table A) in acDialog mode.
The error occurs when pressing "New"... Form2 displays an empty form except for the ID field (which says "New") and the creation date field (which shows the current date). If I enter data up to and including the last data entry field, then Tab, or press the Close [X] button, I get the error. Pressing [OK] will (for Tab) refresh Form2 for a new record, or for [X] will close the form and return to Form1. In both cases the data is saved.
I am really stuck... Why is this happening? What do I have to do to eliminate this error? Or, is there a way to just suppress this message?
Many thanks in advance,
Paul