Results 1 to 2 of 2

Thread: OnLoad SQL statement using VB - Refresh needed

  1. Jun 22nd, 2004, 11:34 AM #1
    samjaynes
    samjaynes is offline

    Thread Starter
    New Member
    Join Date
    Jun 2001
    Location
    Utah, USA
    Posts
    6

    OnLoad SQL statement using VB - Refresh needed

    I have a form in Access2000 which used the OnLoad event to run a vb routine to assign the frmReporting.Recordsource using SQL. It works prefectly. However, I would to be able to refresh the form to recall the VB code again (The code uses Inputboxes and functions instead of queries). I have tried reload and refresh functions with no luck... any idea?
    Reply With Quote Reply With Quote
  2. Jun 22nd, 2004, 02:23 PM #2
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950
    Put the SQL in a separate function, not the load event, then call it whenever you want.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width