Re: macro set value subform record source error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Nikos Yannacopoulos <nyannacoREMOVETHISBIT@xxxxx>
Date: Wed, 06 Apr 2005 10:36:05 +0300

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?

baffled wrote:

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?

References:
- macro set value subform record source error
  - From: baffled

Prev by Date: Save As to copy DB object for monthly backup
Next by Date: Re: Save As to copy DB object for monthly backup
Previous by thread: macro set value subform record source error
Next by thread: Re: Printing a single page only from a button?
Index(es):
- Date
- Thread