fields in small form not updateable, how could i fix?

[KevinSlater]

Hi,

I have an access 2003 form named “frm-PALLET_DESPATCHES” in which I would like to be able to amend the “direction” (drop down section) and “pallets” (entry box) fields which in turn will save the data into a local access table named: “DATA-PALLET_DESPATCHES”. However when I try to amend these two fields in the form access won’t let me type anything into them. (No error message-access just wont allow me to amend the fields)

It appears the problem is related to the forms underlining query named “qry-DATA-PALLET_DESPATCHES” being ready only and I’m not sure how to make this updateable.

The Query has one access table and 3 linked SQL tables, the other option I thought was to perhaps update the query from the form by using some code but not sure where to begin on this.
Any suggestions would be great, I’ve attached a sample from the database with most records removed and a screenshot of the form.

Thanks
Kevin

 

[vbaInet]

Here are the reasons why a query is read-only:

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

 

[KevinSlater]

I think maybe its due to the join type in the query: the querys SQL is below:

If this is the case is there another approach i could try?, i dont think i can join the tables in the query in another way.

SELECT [DATA-PALLET_DESPATCHES].sop_despatch_note_num,
dbo_odln.address,
[DATA-PALLET_DESPATCHES].pallet_type,
[DATA-PALLET_DESPATCHES].pallet_direction,
[DATA-PALLET_DESPATCHES].num_pallets
FROM [DATA-PALLET_DESPATCHES]
INNER JOIN ((dbo_ocrd
INNER JOIN (dbo_dln1
INNER JOIN dbo_odln
ON dbo_dln1.docentry = dbo_odln.docentry)
ON dbo_ocrd.cardcode = dbo_odln.cardcode)
INNER JOIN dbo_crd1
ON dbo_odln.cardcode = dbo_crd1.cardcode)
ON [DATA-PALLET_DESPATCHES].sop_despatch_note_num = dbo_dln1.pickidno
ORDER BY [DATA-PALLET_DESPATCHES].sop_despatch_note_num;

 

[vbaInet]

Look into using subforms.

 

[KevinSlater]

do you mean put the 2 fields id like to update onto a subform instead? and have the rest of the fields that dont need to be updated on the main form?.

Would both form need to look at seperate querys?

 

[vbaInet]

Create separate queries for each table then create subforms for each child table and link the subforms to the parent form accordingly.