Add textbox button in a form

[jackV]

Hi everyone,



I have a question and have searched throughout the internet. I work for a food company and we have to create product specification information sheets. At times we bring in completed food products and repackage into smaller quantities. The issue that arises is we then have to use our vendors product specification information sheets and pull certain information from these sheets. I have created a table and form with a lot I mean a lot of textboxes so the information can be added. My problem is that I do not want to clutter up a form with all the fields that can be filled in. As with each different food product they may have some indicators, no indicators or will have many indicators.

I was wondering if there is a way to create a button using VBA that would dynamically add another textbox so a user could fill in the next field of that particular description group, or even on an after update, ask the user if there is more info to be added and on a Yes click would add a textbox for the next field available?

I have been at this and I have got myself so wound up on this that I maybe not seeing the solution that might be right in front of me.

[ranman256]

Dont ADD the text box, have it already on the form but invisible.

sub on_CLICK()
txtName.visible =not txtName.visible

OR
open another form just for this entry that has all the sub-entries needed and not clutter up the main form.