Unanswered: Creating a Wizard like feel extract program
I'm trying to create a program that will do several things:
Have multiple questionaire forms answered by user..
Save those answers in a table called WIZARD PROFILE TABLE.
Discard those answers if they decide to stop the extraction.
Extract content from table derived from questions on forms.
The trouble I'm having is mainly around how to move from one form to another saving the Q answers to the Wizard Profile table...Really lost on how
to do this one at all.
I can send the DB if someone can help point me in the right direction..
Again mainly, I'm not sure how to pass the recordnumber from form to form to making sure the same record is being updated by the same person for all forms answered.
I dont know about saving or discarding... except if at anytime they press cancel it just deletes the record with that primary key. I will leave that alone for now. Lets get your forms talking to each other first.
Are you comfortable with VBA? (I have seen you helping other people so I will assume that you are).
What type of form transfer methods are you using? (Click a 'Next' button and it opens the next form and closes the first?) The code for that method would be as follows...
Private Sub cmdNext_Click()
On Error GoTo cmdNext_Err
[Forms]![SecondFrmName]![SecondRecordID] = [Forms]![FirstFrmName]![FirstRecordID]
DoCmd.Close acForm, "FirstFrmName"
Let me know how that works. I havent done much VBA recently. My company put that project on the back burner for a while but I am trying to stay current and learn more so let me know.