How to create Many steps for entering 1 record (Wizard-like)? (1 Viewer)

[MyTech]

I want my database user to enter a record thru a wizard. in step 1 he should put in the product info, in step 2 - price info, in step 3 he confirms the new record to be created.

What's the best approach to enter 1 record through many steps?

 

[vbaInet]

Look into using a Tab control.

 

[MyTech]

Thank you vbaInet, I Looked into Tab control.

Now, in step 1, I want customer to see only Page1, and after clicking "Continue" button, he proceeds to step 2 where he see's only Page2.

So far I understand how to let him navigate between pages, but I want him to see ONLY the applicable page. How do I do that?

 

[vbaInet]

Set the Visible property of each page accordingly.

 

[MyTech]

I made my path thru your advice, thanx again vbaInet.

Just instead of playing around with "visible=true/false", I set the TabCtl:Type to None (=hide tabs), and to get to page 2, I used SetFocus to a control in page 2.

 

[vbaInet]

Good job for taking the initiative! Glad to know it's resolved.

 

[MyTech]

OK, next step.


For "Add SINGLE Product" I used TabControl-Pages in a SingleForm. No subform was needed.




NOW:


I also want an "Add MULTIPLE Products" form, for user to be able to enter MANY records at once, also in wizard-like style.

What's the best approach to THAT? What do I need to do/know MORE?

Subform? TempTable? Anything else?

 

[vbaInet]

Think tab control, multi select list boxes, subforms, combo boxes.