I have created a form and "connected" it to a table in my database. I have set the "Data Entry" and "Allow Additions" properties of the form to "Yes" because I want the form to simply allow users to add new records. I do not want the user to view or edit existing records from this form.
I have defined Control Source information for each of the text fields, and when I created the form, I used the wizard functionality to define the "Add a record" functionality for the "submit" button.
When the form is displayed, all the text fields display text reading "#Name?". The information I have found on-line says that the Data Entry and Allow Additions properties should take care of this issue but, it hasn't.
I have also tried things like this:
=IIf(IsNull([MyTable]![SomeColumn]),"",[MyTable]![SomeColumn])
and
=IIf(IsError([MyTable]![SomeColumn]),"",[MyTable]![SomeColumn])
in the Control Source definitions of the fields, and that has no effect either.
I suspect I have missed something in my form's setup that is causing this.
Any help would really be appreciated.