locked
ole object RRS feed

  • Question

  • hi,

    i have a form that has many tabs on it and a form on each tab. on one tab  i have a form and on that form i have a macro  that when i double click on a line another form will show  

    this is the macro on the line in the form

    [Forms]![status]![rejected subform1].[Form]![P/O No].[Visible]
    

    this is the line i have in my query

    [Forms]![status]![rejected subform1].[Form]![P/O No]
    

    this works fine  with tabs in a form and th

    but i now have access 2013 and i have used a navigation form  and put the form with the macro  on it but it did not work  as i get an error  

    " the object you referenced ithe in visual basic procudure as an ole object is not a ole object

    i have changed the macro and the query but still get the same error 

    [Forms]![status]![NavigationButton11]![rejected subform1].[Form]![P/O No].[Visible]

    any ideas why this is wrong 

    steve

    • Moved by Reed KimbleMVP Sunday, February 1, 2015 4:15 PM VBA posted to VB.Net
    Sunday, February 1, 2015 10:23 AM

All replies