I'm interested in using some sort of status bar on my form since some of my programs take 2-5 minutes to run. Can someone show me the correct code or setup to display a status bar. One of my programs for example will compare a 2 tables (a master table and a raw data table). The tables are the exact same fields but I want to match records and field data for any discrepencies. If you can show me a site with examples of this that would be great too. Thank You for any help.

The staus bar is updated manyally utilizing Access's SYSCMD function, with arguments acSysCmdInitMeter nad acSysCmdUpdatemeter. the problem you'll have is determining what percentage of the program is complete and being in a position to set acSysCmdUpdatemeter.

If you're doing a long query, the status bar doesn't do you any good because you have to adjust the status bar and you may not be able to.

A better practing is to use the acSysCmdSetStatus and acSysCmdClearStatus to create a messagge in the window status bar. I used it especially when I'm manually going through a record set of thousands of records or parsing data. The user will constantly know where the program is.

Take a look at the Access Help menu SYSCMD function.