keeping current entry in field until changed

[Chazcoral]

Is it possible to set a drop down or text box up so that after completing a page of entries the next page will keep those fields until they are changed?


E.G. I choose my name in a drop down box and today's date in a test box, after completing all other info and push enter when the form moves to empty page my name and date are still displayed unless I change it.

[pbaldy]

One simple method:

http://www.mvps.org/access/forms/frm0012.htm

[chazcoral2]

In this form I have several test boxes and combo boxes. Is there a way to make it only copy two or three of them rather than all of the boxes?

[pbaldy]

The method I posted only does one field. Did you use some other method?

[chazcoral2]

No, I copied and pasted you code into control tip, and the results are that it copies everything. Did I applied it to the wrong location?

[pbaldy]

I don't understand what you mean by control tip; no code would run there. The typical event would be the after update event of a control. It would only affect that control.

[chazcoral2]

Here is the On click event proceedure for the command button. what do I need to change?

Private Sub Command60_Click()
On Error GoTo Err_Command60_Click

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdRecordsGoToNew
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdPaste
Exit_Command60_Click:
Exit Sub
Err_Command60_Click:
MsgBox Err.Description
Resume Exit_Command60_Click

[pbaldy]

That is not the code I recommended using. That copy/pastes an entire record. Did you not want to use the method I posted?

[chazcoral2]

This is the hyperlink that you provided for me. It takes me to the code that I used. I must not have recieved the other recomendation that you sent. Can you send it again please

http://www.mvps.org/access/forms/frm0012.htm

[pbaldy]

Are you clicking further into some other part of the site? Here's what I see when I click on the link.

[chazcoral2]

Ok I think I'm understanding where I missunderstand.
I have pasted const cQuote=""""
me!Control.DefaultValue = cQuote & me!Control.Value & cQuote Into on cick event proceedure. Now when I click on the command button it opens the event proceedure. I'm assumed that I needed to put the combo box name that I want to copy in Quotes but it errors. So What am I doing Wrong?

[pbaldy]

You would replace Control with the name of your combo.

me!ComboName.DefaultValue = cQuote & me!ComboName.Value & cQuote

[chazcoral2]

Here is what my code looks Private Sub Command60_Click()
On Error GoTo Err_Command60_Click

Const cQuote = """"
Me!Combo37.DefaultValue = cQuote & Me!Combo37.Value & cQuote
Exit_Command60_Click:
Exit Sub
Err_Command60_Click:
MsgBox Err.Description
Resume Exit_Command60_Click

[chazcoral2]

Got It!! Thank you very much, thanks for your patience with me. You really were veruy helpfull

[pbaldy]

Happy to help; glad you got it working.