Blank Popup form - not showing any controls

[Williams485]

Hello Access Forum,
I've created a popup form with a few controls but, when opened, the form is blank (including the OK and Cancel buttons that were already on there). I've done some reading but can't find a clear answer/solution. What am I missing?
Thanks

[orange]

Please show us a jpg of your form, and any associated code.

[Williams485]

There is currently no associated code. There are two embedded macros - one to close the form with save, the other with a prompt.

I've included design view and form view, below.



I appreciate your anticipated help.

[orange]

If you go to design view, and show properties, Data - what is the Record Source of the Form?

[Williams485]

The Record Source is Clients.

[orange]

Is there an attribute that says Data Entry? -- it would indicate the Form is for entering new data only. If so set it to Data Entry No, and see if that helps.

[Williams485]

Yes. Setting the Data Entry property to 'No' seems to have resolved it. However, the form now loads with values from the table, instead of what I want it to do (open blank for new data entry). How can I achieve this?

[orange]

Well, I think that is what you had before and was the basis of your post.
If you set the Form to DataEntry Yes, you will only see data as you enter new records.

If you want 1 form to do Data Entry and 1 Form to show all the records in the table, I think you need
a) 2 forms, or
b) some vba code to change from DataEntry Yes to DataEntry NO.

But you have to be clear on WHAT exactly you want. I think your original Form work the way you want, but you weren't aware of the DataEntry property.

[Williams485]

Thanks for your input; my form now does what I want it to because I have both the DataEntry and AllowAdditions properties to Yes. The desired result is that my form now opens with all controls visible and allows input of new data.

I don't quite understand how changing these properties made the form controls visible (as opposed to what is shown in the 'form view' jpg above), as was the basis of my original post - albeit my use of the word 'blank' perhaps mean empty form controls, rather than no form controls. However, my form now works as intended.

Thanks

[orange]

Glad you have it working.