Cant add to form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.
I have a form based on 2 queries, which in turn each draw from 2/3tables. I
have managed to get the form to show all required fields and draw the data
from these queries correctly. I have allowed additions and data entry in the
form's properties. Why cant I update or add records to the form and how can
I correct it?
Thanks
 
If the Query being used as the RecordSource for the Form is not updateable,
you won't be able to edit the data on the Form.

Open the Query by itself and see if you can edit data / add new Record in
the DatasheetView of the Query.
 
You are right, I dont get the option to add a new record to the
queries..........
How do I make the queries updateable?
Thanks for your help.
 
I have set the forms recordset type to Dynaset (inconsistent updates) in the
hope to allow the form to update the unupdateable query, however this has not
worked. What could I try next?
 
I suspect there is something wrong with my relationships and the set-up of my
queries. This is the lay-out
Tables
Budget Hours - PK Sales Order (no dups)
Sales Orders - PK Sales Order (dups OK) and Order ID(no dups)
Joined on Sales Order

Tables
Sales Order Authorisation - PK Sales Order (no dups)
Security/Export/QA Requirements - PK Sales Order (no dups)

I have 2 queries
Budget Hours and Security Query
Join properties - on Sales Order. Option 1 only incl rows where both are
equal.
Sales Order and Authorisation Query
Join properties - on Sales Order. Option 2 all records from sales order and
only those from Sales order authorisation that are equal. This is a one to
many join as there might be many sales order entries but they need only one
authorisation.

I am sure there is something wrong here, but the longer I look at it the
less I understand what is going on!! Any assitance would be much appreciated.
 
Recordset type doesn't help in this case. The Source Query is not
updateable so Dynaset still returns Read-only.

Some Queries, especially Queries that involve more than 2 Tables will not be
updateable.

Check Access Help on "Updatable Queries". One of the Help topic shows a few
different techniques to convert an unupdateable Query to updatable.
 
Checked out the help file - thanks!

Van T. Dinh said:
Recordset type doesn't help in this case. The Source Query is not
updateable so Dynaset still returns Read-only.

Some Queries, especially Queries that involve more than 2 Tables will not be
updateable.

Check Access Help on "Updatable Queries". One of the Help topic shows a few
different techniques to convert an unupdateable Query to updatable.
Click to expand...
 
Back
Top