macro set value subform record source error

B

baffled

Using a macro and the on click event to set the record source of an unlinked
subform based on a value in the textbox control [NewValue] in the main form.
Getting message " You tried to run a visual basic procedure to set a property
or method for an object. However, the component does not make the property
or method available for Automation Operations."

action SetValue
item [Forms]![frmMain]![frmSubform].[Form].[RecordSource]
expression [NewValue]

What am I doing wrong?
 
N

Nikos Yannacopoulos

That looks funny... what exactly are you trying to do? Are you asking
the user to type in the name of a query, or an SQL expression, or what?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with form--subform 5
Trying to populate data using a Macro 3
DLookup 7
What are automation operations in Access and how can I change them 2
Automation object errors 2
VBA Syntax for subform record source change 6
Adding a record to a subform with a macro 2
Using set Value 2

Top