recordset not updateable

[kdt]

I'm having a problem updating a form. The query from the form is based on two other queries, one of these queries is based on a table from an external database.

I want to use the Form to populate only data on my own database using a checkbox with:

If IsNull (Me.ReceiptDate) Then
ReceiptDate= ExternalReceiptDate 'where ExternalReceiptDate is the receipt date from the external table
End If

I have checked to make sure that the "unique values" of the queries are all set to No.

As I will only be updating data to tables that are on my database that are updatable. I'm hoping that someone can offer some advice if this is possible and why I'm still getting "recordset not updatable" when trying to enter any data to my data fields in the form.

Thanks

 

[IgorB]

Make sure your query does not have 3 sources which could cause not updateble problem

 

[kdt]

thanks a lot for the imput guys, I will look into this further and see if i can get update rights to the external table.

Cheer