Form Data Entry

[afa]

Hello,

Why is it that even after I set DataEntry to "Yes", does my form populate with the first record in the table.


Does it have anything to do with the fact that my table is now connected to an ODBC database?

[pbaldy]

Shouldn't. What code is used to open it? Or does any code run when the form opens?

[Missinglinq]

As Paul suggested, DoCmd.OpenForm can sometimes cause the secondary Form's Properties to be ignored.

Setting the Data Entry property in code, rather than in the Properties Pane, can sometimes override the above behavior:

Private Sub Form_Load()
 Me.DataEntry = True
End Sub

Also, if the Form, itself, is Read-Only, the first Record will display, even with Data Entry set to Yes.

Can you, in fact, add a New Record, after the Form is opened?

Linq ;0)>

[afa]

Shouldn't. What code is used to open it? Or does any code run when the form opens?

No code runs when the form opens as far as I know, it is just an OpenForm command.

[afa]

How do I change the form to not be Read-Only?

[afa]

After, entering the code provided Form_Load() in the On Load as an Event Procedure, it still showed the first record instead of the blank record

[pbaldy]

What is the record source of the form (table or query)? If a query, can you add a record directly in the query? I'm guessing not:

http://allenbrowne.com/ser-61.html

[afa]

The record source of the form is a table.

[pbaldy]

Can you attach the db here?

[afa]

I could, however the tables will not work due to the SQL tables being connected through an ODBC connection.

[afa]

I wouldn't mind sharing my screen, if you have Skype for Business or other means?

[afa]

join.me is a good sharing site

[pbaldy]

If you open the linked table in Access, can you add a record?

[afa]

I would not like to disconnect the tables from the SQL server because this was not a problem when the tables were local in the Access database. Once I made the SQL connection, there was an issue. I did this in another database once (using a SQL connection to a table), and it was not a problem. Now it seems to be.

[pbaldy]

I didn't suggest disconnecting them, I asked if you could add a record to the linked table. If not, my guess is the SQL Server table doesn't have a primary key; that makes it read only when linked.