var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Copy value from an Unbound combo...
Hi! I have this "Login" form where it has an Unbound combo for the user to choose the "user name". Now, I'd like to create a "access-log" table where I could track who logged in and at what time.
My only problem here is just to copy or tranfer the VALUE (UserID) of the Unbound combo (UserID combo-box) to the "tbl_accesslog".
Could be a way to copy a value form an unbound combo-box to another table?
I'll really appreciate your help here! Thanks in advance!
Use an insert query.
Dim sql As String
sql = "INSERT INTO tbl_accesslog (UserID, access_time) " * _
"VALUES (" & YourUnboundComboBox.value & ", date())"