Thanks for the Welcome.

To explain what I'm doing a bit more, I'm using an unbound form, which will update ~5 different input tables. Because of nature of the data (and future queries off of this), I needed to use a form that would update different tables; some of the data comes in a 1xn matrix and some of it comes in a nxm matrix.

I guess is there a way to have a global procedure that will apply to the form, rather...

I'm using access 2003. I want to be able to set a DB to have user name's and passwords, which will restrict access to editing specified queries/tables. I'm not sure what I should be searching for. Can someone direct me to keywords/access fields to be able to do this?

thanks!

I'm using access 2003 and Windows 2000. I have a form with a bunch of VBA code. When I'm debugging the code attached to the form, sometimes I will get an error that will stop the code. I notice then that the form window in the Taskbar disappears and I only see the window for MS Access. The only way I can remedy the situation is by closing Access and reopening it. Is there another way to avoid this? Are there some settings that are being modified...

Hi - I'm using Access 2003.

I have an input form that I'm trying to link to multiple tables. I have a command button that updates all the tables with the ~40 textboxes which the user inputs the values.

I'm wondering if there's a way I can make the command button disabled until the value of the text box differs from that of the input tables. The only way I can think is to have a subroutine for every text box "after...