autofill

[R. Fuller]

Good afternoon. I posted this question a couple of weeks
ago. But no one answered. Could someone please give me a
hand with the situation outlined below.

I don't know why it is so difficult to perform such a
simple task as autofilling form fields based on data
entered or selected to populate one field. I believe that
MS Access is a well designed product, but it could use
some updating when it comes to enabling users to program
common and seemingly simple functions.

For example, I get the error listed below when I try to
autofill fields based on data I select for a related
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.
..

 

[Rick Brandt]

Good afternoon. I posted this question a couple of weeks
ago. But no one answered. Could someone please give me a
hand with the situation outlined below.

I don't know why it is so difficult to perform such a
simple task as autofilling form fields based on data
entered or selected to populate one field. I believe that
MS Access is a well designed product, but it could use
some updating when it comes to enabling users to program
common and seemingly simple functions.

For example, I get the error listed below when I try to
autofill fields based on data I select for a related
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.

Please explain this statement above. Event properties should either contain the name
of a macro, the name of a function, or the phrase "[Event Procedure]". The latter
indicating that the code in the form's module corresponding to this specific event
should be run. It sounds like you have the name of a query entered in there.

 

[R. Fuller]

Sorry, you are right that 'xxx' is the name of a macro
that performs an 'update to' function. However, it
doesn't seem to work since I keep getting the error
message discribed earlier. I would rather not use the
event property at all and simply use the 'autolookup'
function explained in the help documentation of MS
Access. However, when I follow the procedures outlined
there I get the same error message. I just don't know
what is meant by "the object does not contain the
automation object...

Thanks in advance for any help you can provide.

-----Original Message-----

Good afternoon. I posted this question a couple of weeks
ago. But no one answered. Could someone please give me a
hand with the situation outlined below.

I don't know why it is so difficult to perform such a
simple task as autofilling form fields based on data
entered or selected to populate one field. I believe that
MS Access is a well designed product, but it could use
some updating when it comes to enabling users to program
common and seemingly simple functions.

For example, I get the error listed below when I try to
autofill fields based on data I select for a related
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.

Please explain this statement above. Event properties should either contain the name
of a macro, the name of a function, or the phrase "[Event Procedure]". The latter
indicating that the code in the form's module

corresponding to this specific event