Problems Writing Data to Table

[idbr]

Hi,

I have a form that gets it's data from a query. The query pulls data from a local table and a read only networked table.

I want the user to be able to add notes to the record displayed by the form. However, because I have the read only table in the query it won't let me write data back to the local table - despite this table being fully read/writable.

Any suggestions for a workround (other than creating a new table from the data)?

I'm running A2002 on an XP box.

Thanks, Iain

 

[lupins46]

Use a subform to display the read-only data and restrict your query to the read-write table.
or
Use Dlookups to get the the read only data (bit slow possibly).