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

 

[PieterLinden via AccessMonster.com]

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

Is the query you're working on somehow not updateable? You should be able to
modify the data in the query provided the query is updateable... No need for
the table at all.

 

[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