viewing records in a form

R

rc51wv

I have a form titled FrmUsers that's used for admin privledges to enter new
user id's, passwords, and security level into the database. It cotains 2 text
boxes (for the user id and password) and a combo box(for the 3 selectable
security id's). Right now all you can do is enter new information into the
fields and have them placed in the AddUsers table.

What I'm trying to do, when you open the form, is have the 2 text boxes,
txtUser and txtPass, and the combo box, cmbSec, filled with the corresponding
information from the AppUsers table. So basically you can use the record
navigation buttons at the bottum of the form to browse through each user id,
password, and security level that's stored in the table so you can delete
them if necessary. Also, I still need to be able to enter new user's and
their information into the table.

TIA for any help.
 
E

everettwelch

Is there a particular reason why you do not have the form's contro
source as the AppUsers table or a query of it? You can always open th
form in the add mode which will not show the existing records, or th
edit mode that permits additions
 
Top