Hello, hope you can help me.
My main form (designed from table tblmembership) contains members details eg Ref, address etc. I have created a subform that records the ongoing annual dates that membership is/will be due for renewal.
The continuous view subform works great for existing data, the link to membership number shows past renewal dates for that one member (I can even amend them). However, my problem is that when I try to enter the next renewal date for that member, I get the message: The LinkMasterFields property setting has produced this error: ‘the object doesn’t contain the Automation object ‘tblmembership’
So basically what I want to do is assign a renewal date to a member without having to manually type in the membership number on every renewal date record to create the link to make it work.
I know it can be done, as older databases on our system have this and it works – I just cannot track back to how it has been set up. As a self-taught database designer, please be as simple as possible with your answers as I tend to do all the design through design view, not SQL (basic understanding) or visual basic (none whatsoever).
Thank you
Jo.
My main form (designed from table tblmembership) contains members details eg Ref, address etc. I have created a subform that records the ongoing annual dates that membership is/will be due for renewal.
The continuous view subform works great for existing data, the link to membership number shows past renewal dates for that one member (I can even amend them). However, my problem is that when I try to enter the next renewal date for that member, I get the message: The LinkMasterFields property setting has produced this error: ‘the object doesn’t contain the Automation object ‘tblmembership’
So basically what I want to do is assign a renewal date to a member without having to manually type in the membership number on every renewal date record to create the link to make it work.
I know it can be done, as older databases on our system have this and it works – I just cannot track back to how it has been set up. As a self-taught database designer, please be as simple as possible with your answers as I tend to do all the design through design view, not SQL (basic understanding) or visual basic (none whatsoever).
Thank you
Jo.
