Create Table from form

[c18rch]

Hi

I am trying to create/populate a table from a form based on data entered in that form.

ie. Data is entered into the form either by direct input or from data stored in table X, this data is then used to create/populate a new table with an unknown number of data points (this depends on what is entered in the form). The new table is then displayed within the form.

I am fairly new to access, is this possible?

Cheers

 

[boblarson]

I think you may be trying to achieve something that is not how Access is designed for using. It is possible, but is it wise and good? I'm not sure. Why do you need to create a table like this? What is the purpose? There are likely other ways (more of the way Access is designed for) to achieve the end-results you are looking for, but not in the way you are looking to do.

 

[c18rch]

Someone using the form will entere a start distance and an end distance and then the distance increments. The form will then calculate the data associated with each distance.
eg
Start 10
End 20
Increment 2

Data Produced:

10 a
12 b
14 c
16 d
18 e
20 f

Where a-f is the calculated data.