Sequential Optional Items on Form

[DonkeyKong]

I'm creating user form items (text boxes/combo boxes) for a user to enter data in. In this case it would be for a part. What I would like to happen is, if there is more than 1 part, then after the first part is entered, another part entry item(s) are added below the first one. For a virtually unlimited amount of parts. BUT if there is only say, one part to be entered, then the next section of selection appears directly below the blank next part. Sooo, something like this.......


Invoice:

Part1: (THE PART HERE)
Part2: (THE PART HERE)
Part3: (THE PART HERE)
...
...
...
...
Partn: (THE PART HERE) - blank

(aButtonThatProcessesThis)

OR.........

Invoice:

Part1: (THE PART HERE)
Part2: (THE PART HERE) - blank

(aButtonThatProcessesThis)

Is this possible?

 

[CJ_London]

I can't quite visualise what you are trying to achieve but you can certainly have more than one input area on a form.

You do this by having a single form with two or more subforms on it set to datasheet or continuous form. These could be side by side or one below the other.

Depending on requirements, the single form (it is called the parent form) will typically be set to allowadditions =false whilst the subforms will be set to allowadditions=true. In both cases dataentry would be set to false. The other data properties, Allow Deletions and Edits, refer to lines already entered and should be set depending on whether you want the user to be able to do these things or not