INSERTINTO Help

D

David

I have a table to track ID's and Passwords. User's will check them out. I
have the same table storing all records. When user checks in an ID, i will
modify the status to "HISTORY", populate the checkin date.

In a continuous form, I have a command button on each record to check in
that particular record.
I would like a SQL statement that will insert a record in my table, and copy
the field "Login" and the field "Password" to the new record.

Table Name: tbl_Logins
Field Name: Login, Password
Continuous Form: frm_Login_Open

Any assistance you can provide would be greatly appreciated.
 
W

Wolfgang Kais

Hello David.

David said:
I have a table to track ID's and Passwords. User's will check them
out. I have the same table storing all records. When user checks in
an ID, i will modify the status to "HISTORY", populate the checkin
date.
In a continuous form, I have a command button on each record to
check in that particular record. I would like a SQL statement that will
insert a record in my table, and copy the field "Login" and the field "Password" to the new record.

Table Name: tbl_Logins
Field Name: Login, Password
Continuous Form: frm_Login_Open
Click to expand...

What about the status and chekindate? Ok, so only Login and Password:
"Insert Into tbl_Logins (Login, Password) Values ('" & Me.Login & _
"','" & Me.Password & "')"
For example, run it "On Click" using CurrentDb.Execute ...
 
Top