Access 2007 and forms

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Jasperuk
    New Member
    • May 2007
    • 1

    #1

    Access 2007 and forms

    Ok a real and i mean real complete novice to most things in access so please be patient i know very little about scripts and code.

    Trying to recreate a database at home based on practice during lunch at work.

    What i have is a database at work (Access 2003) which using a form with 2 list boxes on it, the first box gets its data from query1 about the product code and the second list box recovers the description from the same query1 based on the data highlighted on the first list box.

    Very simple and very easy, press the button command button that runs a macro, the macro used a RunCommand action the command being RefreshPage. Refreshing the page re-runs the query updateing the list boxes.

    This all works in 2003 but i cannot find RefreshPage command in the 2007 version i have at home.

    How can i re-create this on 2007 easily i really dont have a great understanding of scripts and codes like i said

    Cheers
  • Denburt
    Recognized Expert Top Contributor
    • Mar 2007
    • 1356

    #2
    Interesting that you don't see it there, I don't have MS Access 2007 however acCmdRefreshPag e is listed on Microsofts site under MS Access 2007 developers reference:

    acCmdRefreshPag e

    Comment

    Working...