confused with append method

[TP takamiya]

here it goes,

i have tabcontrol with 3 page in it. every page consists of 5 text boxes
4 boxes are set visible to false, not until the first box meet the certain criteria and the second box will be visible, when the 2nd box meet the 2nd criteria the box will be visible as well and so on..
the second and third page are the same with page 1. they have 5 boxes each tabpage and same condition as page1.

now, my question is...

how can i append the records in a table in just 1 field without blanks..

let say, on page 1
textbox 1 = 10
textbox 2 = 15
textbox 3 = 20
textbox 4 not visible
textbox 5 not visible
on page 2
textbox 1 = 5
textbox 2 = 18


textbox 3 not visible
textbox 4 not visible
textbox 5 not visible
on page 3
textbox 1 = 3
textbox 2 not visible
textbox 3 not visible
textbox 4 not visible
textbox 5 not visible

the table will appears like this

Table sample
field 1
10
15
20
5
18
3

guys i really need your help.
any suggestions or comments are appreciated
tnx so much

[weekend00]

do you know some VBA? It will realize you goal.

[ajetrumpet]

indeed...basic will help. what you need to do is:

*loop through the textboxes on your form and check for visibility
*is they are visible, append a new record to your table with the FIELD = textbox value

you can append your records by using a recordset OR by simply issuing a currentdb.execute command everytime a value needs to be thrown into the table.

[TP takamiya]

thanks ajetrumpet,

i think that is the answer.

thanks for the reply too weekend00