Form Field showing all table fields

[DMJ]

Gang table properties_zip.zip
frm_GangNEW_zip.zip



I want to create a form to simply add new records to a table but when I create the form, the Gang Name Field populates all the field names. How do I get rid of this?

[June7]

What do you mean 'populates all the field names'? The form is showing existing data?

If you want to add a new record then move to new record row.

[trevor40]

try creating a new form using the form wizard based on the table, add all fields.
then in the properties for the form change 'data entry' to true, you will then have a form that will allow you to add records only and not see any previous records.

[azhar2006]

Private Sub Form_Open(Cancel As Integer)
DoCmd.GotoRecord , , acNewRec
End Sub
Cancel with the navigation buttons

[DMJ]

I have the Data Entry set to true but the Gang_Name field is still showing all four field labels in a list as the attachment frm_GangNEW.zip. I am not able to enter into this field, forced to choose a field name.
I am wondering if it is something set in the table that is why I attached the table properties also.
Really appreciate the help!

[June7]

That looks like a listbox. The listbox is presenting a list of items for selection. I am guessing the listbox RowSourceType property is set to Field List. Access Help has guidelines on creating listbox and combobox.

A combobox will present the items as a dropdown list.

[azhar2006]

DMJ ,
What is the name of the item
Is it possible to attach DB

[DMJ]

frm_GangNEW_zipped.ziptbl_gang_zipped.zip
I am still not able to add new item to the table, the top field is only a drop down of all the names. I have tried changing from value list to field list. I've tried removing the row line. Any other suggestions or combination of things I should be doing?