Textbox controls how many versions on report (1 Viewer)

[DeltaD]

Hey geniuses!
So I've got a sign generator form where I can generate signs.
I would love to have a text box where I can enter in how many I want of a different design. i.e. if it that box was empty, it would only show the normal design, but if the textbox had a qty in it, it would show the normal design and the amount listed of the other design.

Thanks!

 

[Ranman256]

on a form put the text box and the Qty txtBox

tho I'm not sure what to do here....do you want 4 copies?
or 4 different variants? If so, what? ,
different fonts?
or different style you have saved in the db?

 

[DeltaD]

I'd like to have a qty textbox to show multiple copies of the second variant that I would design with VBA code.

 

[DeltaD]

Ok so more details.
There are 2 designs that are used in the area I work in. Design 1 and Design 2.
Design 1 will always be used when printing off signs, but in some cases we use design 2 to indicate an overflow location for the part that design 1 indicates.

The text box, when a qty (say 2) is entered, would show 2 copies of design 2 below a design 1 instance on the report I'd export. If the textbox is empty, no design 2 instances will appear on the report.

Any ideas on the VBA side of things?

 

[Pat Hartman]

Despite the fact that today there are only two options, I would still normalize the table. Then you can have as many designs as you want and each one will be represented as a row. If you have only a quantity for the first design, there will be only one row.