Record won't save with AutoNumber

[matey56]

Hi all,
I have a table with an autonumber. I have a form where users can add records to that table. The autonumber field "ID" will be hidden on the form, I'm just displaying it for testing. Problem is, when I add a new record it populates the ID field but it won't let me save it saying it's blank. What am I missing?


This is the save command the user clicks to save the record.

Private Sub cmdSave_Click() Saved = True
   DoCmd.RunCommand (acCmdSaveRecord)
   Me.cmdSave.Enabled = False
   Saved = False
   Me.Requery
   
End Sub

[Welshgasman]

Upload the DB with enough to see the issue.
You are not telling everything here, not purposefully I admit, but something else is going on.

[matey56]

Upload the DB with enough to see the issue.
You are not telling everything here, not purposefully I admit, but something else is going on.

How do I upload it? It says the limit is 500kb.

[mike60smart]

The example Form is showing the "Plant Code ID" as the PK and is displaying (New). When you enter new data for this record and then move to a new Record or Exit the Form, the data would be saved automatically.
There would be no need for the ON Click Save Event.

[mike60smart]

At the Top of the Site click on the Tab "How to Attach Files"

[matey56]

The example Form is showing the "Plant Code ID" as the PK and is displaying (New). When you enter new data for this record and then move to a new Record or Exit the Form, the data would be saved automatically.
There would be no need for the ON Click Save Event.

I know, but the users requested this On Click event. I'm sure this is where the problem is, but I just don't know why.

[Welshgasman]

How do I upload it? It says the limit is 500kb.

You can create a new db and import just what is needed. By the looks of it, that will be just a table and the form?

In future for full DBs, Save a copy, compact that, then zip it, then upload.

Do you have Option Explicit at the top of each module/form/report?

[matey56]

You can create a new db and import just what is needed. By the looks of it, that will be just a table and the form?

In future for full DBs, Save a copy, compact that, then zip it, then upload.

Do you have Option Explicit at the top of each module/form/report?

I zipped it this time.

[Welshgasman]

I do not see that form?
OK, found it.
That form has the dbo_ table as source, no autonumber field in that table?

I have no clue what you have done.

[davegri]

The recordsource for the form is wrong table.

[matey56]

I do not see that form?
OK, found it.
That form has the dbo_ table as source, no autonumber field in that table?

I have no clue what you have done.

Sorry, that's an old version. Disregard the dbo_70 table. The form should be based on tblPlantCode. I still get the error when using it as the record source.

[matey56]

OK, I figured it out. I had an extra field in the table that I didn't need and was set as required. Sorry to bother!

[Welshgasman]

Yes, you were not matching fields to sources.