macro set value subform record source error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
Back
Top