Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Combo Box in Access 2013 that looks up to reports

    Hi All

    I m designing an access database and on my start up form it gives them a list of options of what they would like to do, with command buttons.

    I am having trouble however with a combo box that has a list of the available reports in the database and then obviously bring up the reports so they can print them. i have managed to bring up the lit of reports from my database but when you click on the selection it does nothing?

    i have looked at some solutions posted on this website for older versions of access and the codes don't appear to work.

    i have this in the row source of the combo box;
    SELECT [Name] FROM MsysObjects WHERE (([Type] = -32764) AND ([Name] Not Like "~*") AND ([Name] Not Like "MSys*")) ORDER BY [Name];

    I think i need to put something in the event of the combo box but anything i put in there doesn't work?!

    Any help and advice would be appreciated.

    THanks

    Kelly

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,537
    Thanks
    0
    Thanked 23 Times in 23 Posts
    Have you tried to run the SQL in a query

  3. #3
    New Lounger
    Join Date
    May 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    THanks Patt

    I think i may have solved my own problem though and it was a lot simpler than i thought! i was obviously trying to over-complicate things!


    Private Sub Combo_Open_Report_Click()
    DoCmd.OpenReport Me![Combo Open Report], acViewReport

    Kelly

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •