unhide multiple text boxes at a time after pressing a command button

[mjquinon via AccessMonster.com]

I want to be able to add a text box everything I press the Add Task button.

Something like this:

___________
| ADD TASK |

then a text box becomes visible

________________________
| |
|________________________|

and repeat up to six times

So far all I have been able to do is to get one text box to show

can any one help plz.

Mike

 

[Marshall Barton]

I want to be able to add a text box everything I press the Add Task button.

Something like this:

___________
| ADD TASK |

then a text box becomes visible

________________________
| |
|________________________|

and repeat up to six times

So far all I have been able to do is to get one text box to show

Whoa! This sounds like an unnormalized table. You should
probably have a separate table for the task data and using a
continuous (or datasheet) subform to display/enter the task
data (no command button needed).

 

[mjquinon via AccessMonster.com]

I'm sry i am new at this so How is it that this subform is created?

I want to be able to add a text box everything I press the Add Task button.

[quoted text clipped - 12 lines]

So far all I have been able to do is to get one text box to show

Whoa! This sounds like an unnormalized table. You should
probably have a separate table for the task data and using a
continuous (or datasheet) subform to display/enter the task
data (no command button needed).

 

[Guest]

If you are absolutely sure you only need a maximum of 6 text boxes then you
can have fields but can you be sure?

Putting "like" information into separate fields can cause havoc when
creating queries and analysing information.

I'm sry i am new at this so How is it that this subform is created?

I want to be able to add a text box everything I press the Add Task button.

[quoted text clipped - 12 lines]

So far all I have been able to do is to get one text box to show

Whoa! This sounds like an unnormalized table. You should
probably have a separate table for the task data and using a
continuous (or datasheet) subform to display/enter the task
data (no command button needed).

 

[Marshall Barton]

I'm sry i am new at this so How is it that this subform is created?

I want to be able to add a text box everything I press the Add Task button.

[quoted text clipped - 12 lines]

So far all I have been able to do is to get one text box to show

Whoa! This sounds like an unnormalized table. You should
probably have a separate table for the task data and using a
continuous (or datasheet) subform to display/enter the task
data (no command button needed).

The really important point here is to get the tables
designed according to the (first three) rules of relational
database normalization. Once you have the task data in a
separate table with a foreign key to connect to the project
table, just create a form based on the tasks table. Then
you can drag and drop this new form onto your existing form.