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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mjquinon - 11 Jun 2007 15:12 GMT

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

Reply to this Message

Marshall Barton - 11 Jun 2007 16:03 GMT

>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).

Signature

Marsh
MVP [MS Access]

Reply to this Message

mjquinon - 11 Jun 2007 16:14 GMT

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 - 6 lines]
>continuous (or datasheet) subform to display/enter the task
>data (no command button needed).

Reply to this Message

scubadiver - 11 Jun 2007 16:25 GMT

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?
>
[quoted text clipped - 8 lines]
> >continuous (or datasheet) subform to display/enter the task
> >data (no command button needed).

Reply to this Message

Marshall Barton - 11 Jun 2007 16:44 GMT

>I'm sry i am new at this so How is it that this subform is created?
>
[quoted text clipped - 8 lines]
>>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.

Signature

Marsh
MVP [MS Access]

Reply to this Message