G
Guest
Hi
I am not sure how to put into words what I would like to do but here it goes.
I have a table which needs to be update from a form.
The form has 3 text boxes which I have no problem with.
I was considering using the subform to create like a spreadsheet / database
that contains 4 columns and about 100 rows.
The for columns will have specific headings and numbers will be entered
under the applicable heading.
Once the numbers have been entered then a button will be selected which will
update the table with the data and provide a total of how many rows were used.
The numbers are reciept numbers and we need to know for example how many of
each column was used.
I hope this makes sense and someone can help me.
All I need to know for now is how to create the columns & rows so whenever a
row is used between 1 to 4 columns that a new row is shown to be able to
enter more numbers.
Thanks
Noemi
I am not sure how to put into words what I would like to do but here it goes.
I have a table which needs to be update from a form.
The form has 3 text boxes which I have no problem with.
I was considering using the subform to create like a spreadsheet / database
that contains 4 columns and about 100 rows.
The for columns will have specific headings and numbers will be entered
under the applicable heading.
Once the numbers have been entered then a button will be selected which will
update the table with the data and provide a total of how many rows were used.
The numbers are reciept numbers and we need to know for example how many of
each column was used.
I hope this makes sense and someone can help me.
All I need to know for now is how to create the columns & rows so whenever a
row is used between 1 to 4 columns that a new row is shown to be able to
enter more numbers.
Thanks
Noemi