Data Entry into Forms

[Lasso]

Im new to Access, and I seem to be getting the hang of it ok, but for the live of me I cant seem to create a form that will allow me to entry or edit records. I must be missing something very basic. Ive looked through multiple texts. Is there a simple text or thread that could help.

[Missinglinq]

...I cant seem to create a form that will allow me to entry or edit records...

Does this mean that you can create a Form but cannot add new records to it or edit records on it? Are you basing your Form on more than one Table? Multiple-table queries are frequently Read-Only.

Linq ;0)>

[Lasso]

Thanks for replying Linq

I can create a Form but not add new records or add records.

I have tried two types of forms. A simple one based on a simple table and a more complex one that is based a query from multiple tables.

Looks like I need to understand Read-Only better? I dont seem to come across this in my researching.

How do you make records editable from a complex Query?

Lasso

[June7]

Are you saying a form based directly on a table is still not editable?

If a query is not updatable then it cannot be used to edit records.

A form should enter/edit records to only one table.

[Missinglinq]

Reasons that a Bound Form cannot have New Records added or existing Records edited include:

1. The File's Read-Only Property (in Windows Explorer) has been set to Yes
2. AllowAdditions/AllowEdits for the Form is set to No
3. The underlying Query the Form is based on is Read Only
4. User doesn't have Read and/or Write Permission for the Folder where the Data resides or there is a connection problem with the network.
5. Folder the File resides in (in versions 2007/2010/2013) not having been declared as 'Trusted'
6. Form's Recordset Type is set to Snapshot
7. All Controls on the Form being Locked or Locked and Disabled.

Linq ;0)>

[Lasso]

Thanks Guiys and apologise for the slow response.

Clearly I need to go back to basics to better understand the concepts of Read Only Queries and Form properties or find another way design wise.

If ok I will do some further investigation and revert if and when I need to

Lasso.