C
CMeys
Guest
I have created an update query that uses a linked field to find information in 1 table and insert it into another table. The query runs properly.
I want to attach this query (preferably) to a form control (if that won't work, to the form itself) via its property so that when data is entered in the linked field, it will look up the information for the other 2 field via the query and insert them in the form (into this table). Whatever method I try (and regardless of what event I try to attach it to) results in the same error to the effect of:
"The object doesn't contain the Automation object 'Master'. ...the component doesn't make the properties or method available for Automation operation."
Note that the table on which my form is based is called Master.
Is there a way to do this? Is there a better way to accomplish this (I am trying to look up and enter the names of a city and state based in zipcode entered and insert them into the table via the form).
Please note that I am a newbie to Access, but had done this previously in RBase for DOS. Thank you.
I want to attach this query (preferably) to a form control (if that won't work, to the form itself) via its property so that when data is entered in the linked field, it will look up the information for the other 2 field via the query and insert them in the form (into this table). Whatever method I try (and regardless of what event I try to attach it to) results in the same error to the effect of:
"The object doesn't contain the Automation object 'Master'. ...the component doesn't make the properties or method available for Automation operation."
Note that the table on which my form is based is called Master.
Is there a way to do this? Is there a better way to accomplish this (I am trying to look up and enter the names of a city and state based in zipcode entered and insert them into the table via the form).
Please note that I am a newbie to Access, but had done this previously in RBase for DOS. Thank you.
