Option Group problem with macro

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a form which has an option group. This is the where condition of the
macro of a choice on the option group
=[tbldocument]![txtExpirydate] Between [Forms]![frmreports]![txtfromdate]
And [Forms]![frmreports]![txttodate]

However when I try to run the macro I get a message that says " The object
does not contain the Automation object 'tbldocument'
What does that mean (in layman's terms)?
Thanks
Tony
 
Tony Williams said:
I have a form which has an option group. This is the where condition of the
macro of a choice on the option group
=[tbldocument]![txtExpirydate] Between [Forms]![frmreports]![txtfromdate]
And [Forms]![frmreports]![txttodate]

However when I try to run the macro I get a message that says " The object
does not contain the Automation object 'tbldocument'
What does that mean (in layman's terms)?
Thanks
Tony
Click to expand...

There seems to be confusion over nomenclature. As I stated in your other
thread, the "txt" prefix suggests a reference to a text box and not a field.
You need to sort that out if you're to avoid further confusion IMO.

Keith.
www.keithwilby.com
 
Back
Top