How do I populate the form with the data entered just previously using auto generated form number

Question

0.00/5 (No votes)

See more:

i have an inquiry form that accepts various fields of inputs from the user. most inquiries have similar fields as the previous set of data entered. So i would like to have a duplicate button to populate the form with previous set of data , using the form number (to be auto generated). Just so that user doesn't have to type the same details all over again.

i have used unbound forms and a table to store details of every inquiry.

What I have tried:

Private Sub b_previous_Click()
'open Previous form
Dim new_ticket As Integer
new_ticket = ticket_num - 1

If Not Me.b_next Then

DoCmd.OpenForm "F_inquiry_new ,ticket_num & Me.new_ticket & "

End If
End Sub

PS. i dont know how to auto generate the form number when a new form is opened,yet. For now i physically input my ticket number in the form.

Posted 27-Jul-16 6:54am

Member 12656807

Updated 7-Oct-16 7:38am

Add a Solution

Comments

Maciej Los 4-Aug-16 8:16am

I don't get you... Can you be more specific and provide more details?
At this moment i understand that you want to type inquiry number to be able to get its details. Next, you want to use that data to create new inquiry. Am i right?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 8278404 · Answer 1 · 2016-10-07T07:38:00

You could always leave the form populated when they submit the form.
Add another button that clears the form and submits, or just clears the form.

And you can also add something like:
Private Sub TextBox1_GotFocus()
TextBox1.SelStart = 0
TextBox1.SelLength = Len(TextBox1)
End Sub

To you textboxes so that it selects all the text when clicked and then they can just overwrite the text in the boxes they want.