Looping and if then

[Chris Wagner]

I am creating a reimbursement template. In it I have two user forms. In one
of the
forms I want the users to be able to click on a "add more" command button so
they can continue adding expenses. Then I have a "finish" command button for
when they are done adding expenses. Is there a loop command that will do
this?

Also, I need to have them enter initials and have certain initials
correspond to a group. For example, if they typed DMA, the finished form
would show 03-Litigation and the initials themselves would never show.

Thanks

 

[Jean-Guy Marcil]

I am creating a reimbursement template. In it I have two user forms. In one
of the
forms I want the users to be able to click on a "add more" command button so
they can continue adding expenses. Then I have a "finish" command button for
when they are done adding expenses. Is there a loop command that will do
this?

This is a bit incomplete.
What actually happens when the ADD button is used?
Where is the information entered?
How much information are users typically entering?

Also, I need to have them enter initials and have certain initials
correspond to a group. For example, if they typed DMA, the finished form
would show 03-Litigation and the initials themselves would never show.

How many of those pairs do you have?
Are they likely to be modified on a regular basis?

 

[Chris Wagner]

This is a bit incomplete.
What actually happens when the ADD button is used?
Where is the information entered?
How much information are users typically entering?

When the add button is used, the user form re-appears so the user can enter
various expense reimbursement fields (client number, amount, date, purpose,
attendees).

The information is placed onto the template

How many of those pairs do you have?
Are they likely to be modified on a regular basis?

I would have approx 75 pairs.
Modified on an infrequent basis

 

[Jean-Guy Marcil]

When the add button is used, the user form re-appears so the user can enter

"re-appers"? Where was it before?
Where is this "Add More" button?

various expense reimbursement fields (client number, amount, date, purpose,
attendees).

The information is placed onto the template

When is it placed?


Still confused.

Above, you first mentioned that the "Add More" button was on the userform.
Now, from your second description, it appears to be on the template itself.

Aslo, above, you mentioned a "Finish" button, from your second description I
cannot see where that button would be or how it would be useful.

I would have approx 75 pairs.
Modified on an infrequent basis

Are you familiar with Variable Arrays?
Or, you could use a two-column drop down control (Where the user sees the
first column and select the initials he wants, but the code inserts the
content of the "invisible" second column".