I been able to recreate it but i am now stuck on the last feature.
I have an order edit form where the master record is on the form and a subform shows the details. Dirty = False End If 'Make sure there is a record to duplicate. New Record Then Msg Box "Select the record to duplicate." Else 'Duplicate the main record: add to form's clone.
Phone FROM tbl USACustomers INNER JOIN tbl USAOrders ON tbl USACustomers. You should use the field from tbl USAOrders instead: SELECT tbl USAOrders.
Postal Code, tbl USAOrders., [Ship First Name] & " " & [Ship Last Name] AS Ship Full Name, tbl USACustomers. Order ID; The query qry USAOrders is not updatable because you have used the Customer ID field from tbl USACustomers.
You don't strictly need the original out-of-print Dragon Mountain, though the maps from there would be helpful, and I highly recommend it.
Last Modified End With End If Exit_Handler: Exit Sub Err_Handler: Msg Box "Error " & Err.
Ho una tabella con un campo data in cui viene inserito il valore di default getdate().
"Run-time error '-2147352567 (80020009) Cannot add record(s); join key of table 'tbl USAOrders' not in recordset".
It gives me a Debug option with the line below highlighted. Cannot add record(s); join key of table not in result set. Please contact Microsoft Product Support Services for more information. I have another form with the exact same code (different table, same scenario as yesterday) that works perfectly.