OnLoad SQL statement using VB - Refresh needed

[samjaynes]

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?

[salvelinus]

Put the SQL in a separate function, not the load event, then call it whenever you want.