General discussion


Access Copying field informaton

By chezacke ·
Hi Everyone,
I am trying to figure out how to give one form the ability to copy text information in certain fields to another form.
I have a form where a quote gets entered for a customer and then I want to set up a way for certain information to be copied through to the sale form to remove the need to re-enter data. I would appreciate any help that I can get from the vast expertise within this discussion group.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Try Technical Q&A forum.

by deepsand In reply to Access Copying field info ...

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.

Collapse -

Use SQL in access...

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

The website at 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.

Collapse -

field form to form data transfer

by the_mayors In reply to Access Copying field info ...

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

Collapse -

Use global variables

by vohalloran In reply to Access Copying field info ...

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.

'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

Related Discussions

Related Forums