macro set value subform record source error

macro set value subform record source error

Post by YmFmZmxlZ » Thu, 07 Apr 2005 00:01:24


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?
 
 
 

macro set value subform record source error

Post by Nikos Yann » Thu, 07 Apr 2005 16:36:05

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?