Hi David,

Dragging the table on to your form creates a sub form.

Instead, set the RecordSource of the form to your table (Property Sheet - Data Tab).
Next, On the Ribbon click on Add Existing Fields (under Form Design) and drag the fields to your form.

Hi Kevin many thanks for taking the trouble to reply - your answer to my questions works fine. Can I take it a further step - as the end-user will not have the knowledge to make the entries outlined in your answer is there a way in VBA that I can make the new field appear on the form? All the end-user has to do is enter the new fields then VBA will kick in and enter the field on the form.

David -
I'm not aware of any way to automate that, even with VBA.
That said I don't think you would want to even if you find a way.  That is your job as the developer.  You don't want end-users working directly with your tabel or adding arbitrary fields to a carefully designed database.

Part of the planning phase is to determine what the users need so that they don't end up wanting a bunch of fields added in the first place.

David, the short answer is that yes, it's possible, but it will involve a level of programming that would challenge even advanced developer students. I've done it before, but it's not easy. I am planning an upcoming video for my developer students that will involve creating new fields at the user level, much like an Android phone does with contacts. Look for it soon.

Why is the user allowed to add fields to a Table?
Shouldn't that be the DBAs job?

Many thanks to all who have replied - appreciated - Richard when you have the Video completed could you email me please? and I will purchase it. Alex the program is for end users with no DBA knowledge - regards all  Dave -

Why would new fields be needed?
Have you seen ABCD?
Might be worth having a way of letting them add extra info in a way you can control than giving them access to the underlying objects.

Hi Alex -the program costs the making of around 450 confectionery products - sometimes the ingredients change due mainly to the availability of ingredients or substitutes. Can you please explain ABCD - thanks Dave

ABCD

Many thanks Kevin - from Dave