R
Reggie Fuller
I don't know why it is so difficult to perform such a
simple task as autofilling form fields based on data
entered or select to populate one field. Could someone
explain what the following error means:
'The object doesn't contain the automation object 'xxx'.
You tried to run a visual basic procedure to set a
property or method for an object. However, the component
doesn't make the property or method available for
automation operations.'
'xxx' above is the name of the query that is pointed to by
the event property of a field on the form once that field
has lost focus.
This is a strange error message. For one, I am not trying
to set a property. I am trying to set the value of a
field with the setvalue option in a related macro.
I have created two tables with a one to many relationship
and followed the 'help' instructions on how to use the MS
Access 'AutoLookup' function. I also created a query that
should automatically fill related fields based on the name
I select from a pull down list in the field based on the
query. For some reason I still get the error either way.
I have tried just using the query and I tried using a
macro with the 'setvalue' function. Please help, thanks.
simple task as autofilling form fields based on data
entered or select to populate one field. Could someone
explain what the following error means:
'The object doesn't contain the automation object 'xxx'.
You tried to run a visual basic procedure to set a
property or method for an object. However, the component
doesn't make the property or method available for
automation operations.'
'xxx' above is the name of the query that is pointed to by
the event property of a field on the form once that field
has lost focus.
This is a strange error message. For one, I am not trying
to set a property. I am trying to set the value of a
field with the setvalue option in a related macro.
I have created two tables with a one to many relationship
and followed the 'help' instructions on how to use the MS
Access 'AutoLookup' function. I also created a query that
should automatically fill related fields based on the name
I select from a pull down list in the field based on the
query. For some reason I still get the error either way.
I have tried just using the query and I tried using a
macro with the 'setvalue' function. Please help, thanks.