Access Copying field informaton

This is a tech. problem, in search of a solution.

It properly belongs in "Technical Q&A," not in "Discussions." Please re-post there.

Not only will you be more likely to attract the attention of those seeking to provide answers, but you will also make it easier for those seeking discussions to find such.

Thank you.

If your using access you can use the SQL commands with DoCmd.RunSQL "sql command here".

The website at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp has a very good list on how to use SQL in access.

If you get stuck let me know, it took me a few days to figure out how to use SQL since I've never used it before. I worked out how to copy any data from any field in one form to any field in a table.

r u still interested in finding how to do this or have you figured it out?
can you understand vba (access's visual basic programming language

Create global string variables in a module in VBA. You can populate the variables using an event such as textbox_exit. Then you can put the values of these variables in the sale form when it opens.

Example:
'You create global variables in a module:
Public strUserID as String
Public strCardNum as String

'Then when an event occurs (in this case a button is clicked), put the user id in a string
strUserID = CStr(txtUserID.Value) 'CStr converts the value to a string
'put the card number in a string
strCardNum = CStr(txtCardNum.Value)

'When the new form opens reverse the process except you don't need to convert again

txtUserID.text = strUserID
txtCardNum.text = strCardNum