Forum Discussion
Only existing records showing in form
Hi I have a form where the Data Entry option is set to Yes. Unfortunately though, the form only shows existing records and doesn't allow the option to add new ones. The query on which the form is b...
Hi,
You write
> Data Entry option is set to Yes
This would mean that in this form you only can enter new records, not see any existing. Therefore I presume that you mean the Allow Additions property. Correct?
In that case control if the query is updatable. Queries with multiple joins often are not, e.g. because the join fields are not indexed enough restrictively. So, in case your query is not updatable, then in the query editor delete one table and control if this changes the updatability. If not, delete the next table etc. until you find the guilty join.
Servus
Karl
*********
Access-Entwickler-Konferenz: https://www.donkarl.com/?AEK
Access DevCon: http://AccessDevCon.com
Access FAQ: https://www.donkarl.com
- Thanks for your assistance Karl. Your suggestion worked. Yes, I meant Allow Additions.
Much appreciated.
Dean.
