cant add new record

[bigmac]

hi all can you help please , I have a form that works ok but when i want to add a new record i click on the new record icon on the bottom of the form and it then opens up a new blank record BUT i cannot write in the texboxes or copy and past into them, any ideas please

 

[Minty]

Is the form bound directly to a table or a query. If the latter is the query updateable? (open it directly and see if you can edit the records)

 

[bigmac]

hi minty, i have opened the query and cannot enter any new records

 

[Minty]

That will be the cause of your problem. You may need to look at how the tables are joined in your query, or possibly change your design to use a sub form to allow you to update / add records.

 

[missinglinq]

Allen Browne has an excellent article that explains why Multi-Table Queries are frequently Read-Only:

Why is my query read-only?

Linq ;0)>