PDA

View Full Version : MS Access Linkmaster Error


Wop
Feb 13, 2006, 06:45 AM
I have created a simple database of products. I need to be able to enter an order that would update an ordersdetail table. I created an order form with a subform for entering product order. (I referred to the Northwind database for help). Everything seems fine except that when I try to enter data in the subform, I receive a message "The linkmaster field property setting has produced this error: The object doesn't contain the automation object 'Orders'." I do not know VB and therefore did not use any code as they did in the Northwind database. I have relationships set up that appear to be working fine. Though the error message appears I am still able to input data. Is there some simple way to fix this. Thanks.

ScottGem
Feb 14, 2006, 07:59 AM
It sounds like the problem is in the link between the mainform and the subform. If you select the subform in Form Design and check the Properties Dialog in the Data box you should see the link fields. It should be Orders.OrderID to OrderDetails.OrderID.