Form to get data. With a button to save them to a table. Access 2007

[blademike]

Hi guys, I'm new to Access & SQL. Currently using Access 2007. What I have:

1) Table: Employee( empID, empName, email, pwd, ... )
2) Form: - Record source ( SELECT empName, email, pwd FROM Employee )
3) 1 combo box. cmbName. Row Source (SELECT Employee.empName FROM Employee;
4) 2 textboxes . txtEmail and txtPwd
5) Button : - Register (no info) and Close form ( Close form button created with button wizard )

Notes:
email field has (Like "*?@?*.?*") validation
Everything is unbound. I guess.I'm not sure with the term though. Sorry

The user is to select his/her name. Type the email and password and click Register. Then the Register button should copy the data to the table and wont allow duplicate email or duplicate password.

I have no idea on how to do it.It is required to use the register button. I found the DAP articles but it's not supported in Access 2007 anymore and I need to perform this on a form.

What coding / setting i need to put on the Register button? Do I need to leave the validation rule in the table or delete that and make the Register button handle the validation. Please help. Sorry if my explanation is not clear. Questions are welcome. Thanks again

 

[Guus2005]

Your form is bound. Which means that the datasource is filled and the controls on your form dito.
Remove the datasource.
Behind the register button you can check and do whatever you want.

Post your db or a subset and we'll have a look.