Form Calculation (1 Viewer)

K

kbrennan856

New member

Local time

Today, 01:51

Joined

Sep 17, 2015

Messages

2

• Sep 17, 2015

• #1

Hi,

I am creating a form which contains a field - Number of boxes:
When the value is selected form a drop down list i want it to display input boxes based on the number of boxes entered.

 

P

plog

Banishment Pending

Local time

Yesterday, 19:51

Joined

May 11, 2011

Messages

11,638

• Sep 17, 2015

• #2

How many input boxes maximum? What I would do is put that many on the form, hide them, then after a selection is made in the drop down, unhide that many of them.

 

K

kbrennan856

New member

Local time

Today, 01:51

Joined

Sep 17, 2015

Messages

2

• Sep 17, 2015

• #3

Basically,

The form is going to be used by guys who have to weight items in a box.
They first have to select the number of boxes they have which should display boxes based on that number.

IE If i have 5 boxes I would select 5, and then 5 boxes would Appear below and i could enter the weights of each 5 boxes.

Thank You For you super fast reply !!!

 

P

plog

Banishment Pending

Local time

Yesterday, 19:51

Joined

May 11, 2011

Messages

11,638

• Sep 17, 2015

• #4

My gut tells me a subform would be a better way to go. With a subform, they can enter as many records as they need. 5 boxes--5 records, 22 boxes, 22 records, etc.

 

M

mjdemaris

Working on it...

Local time

Yesterday, 17:51

Joined

Jul 9, 2015

Messages

426

• Sep 18, 2015

• #5

It also depends on how and what data you are storing. If you have a record for each box, then this is probably not going to work out well. Otherwise, you would need additional tables to store the records and use a subform as plog suggested.