Form List Box

[tpcervelo]

My application is to import a dynamic Excel workbook (not a static name or location), run a number of queries against the imported data and create a table that will be uploaded (appended) to a ODBC linked table. I have all of this working manually so I know my queries are good and the upload completes without problem. My next goal is to put a Form wrapper around it so the user can 'push' the button and make it happen. The code behind my 'Select Excel' command button gets the Excel file (thanks to code written by Ken Getz that I found on an Access forum...much appreciated) and runs the queries and upload. My issues are as follows: I have a List Box based on a query that I want to display the final table for upload and stop to let the user confirm that it is ok to run the upload. The problem is that the List Box populates immediately on Form load rather than waiting until the queries are run...therefor getting previous contents of the query. Also, none of the Field names show. And I have no clue how to stop and ask the User for confirmation to run the final upload query.
Any help or pointing me to samples or tutorials will be much appreciated.


thanks...

[NTC]

the List Box populates immediately on Form load rather than waiting until the queries are run...

**Its behavior is normal - that is just the way it is. You could implement it to be not visible on load, and then in your command button after your macro run command (or sequence of tasks) you could make it visible and also requery - so that it will have the new info....


Also, none of the Field names show.

**Don't understand what is meant on this point.

hope this helps a little.