Create Table from a Form

[Esmerelda]

I have a continuous form which selects data from a query:

TSL Value A Value B Unbound Column
123 50 25
456 98 97

I want to be able to create a table to be later used in an update query
(unless someone can suggest how to directly create the update query) with the
fields TSL –matching the records in the form & then the Unbound Column with
the values I enter into it (different one’s for each TSL).

Would I need to turn my existing query into a make-table query with an extra
column for me to add the ‘Unbound Column’ data? Or is there a way of doing it
without creating extra tables?

I’m capable of using & picking my way through VBA

Thanks

 

[Mike Painter]

I have a continuous form which selects data from a query:

TSL Value A Value B Unbound Column
123 50 25
456 98 97

I want to be able to create a table to be later used in an update
query (unless someone can suggest how to directly create the update
query) with the fields TSL -matching the records in the form & then
the Unbound Column with the values I enter into it (different one's
for each TSL).

Would I need to turn my existing query into a make-table query with
an extra column for me to add the 'Unbound Column' data? Or is there
a way of doing it without creating extra tables?

I'm capable of using & picking my way through VBA

Your unbound column should be bound for two reasons.
1. It is the proper way to add information in a relational database.
2. Anything you add in one unbound textbox in a continuos form will repeat
in all of them.

Unless Value A and Value B are different (Like price and quantity) it s
likely that you don't have a properly normalized table.
If A and B are something like Monday and Tuesday, you will have problems in
the near future