Transfer from Form to Table

[aingram]

Hi All,

Im trying to make up a vb command to send date from a query based from to a table i have no clue how to even start.

The database is to record when a item is inspected so a user would type the date in to a unbound box and then at a click of a button the date along with the id code will transfer in to a table so that i can compair the difference between the dates of any one item

is this possible and how???


Many thanks in advance

 

[CEH]

Sounds like your thinking a bit backwards.... First have your table... include field for date and ID. Then have a query, could be only the fields from the one table. Then your form is built on this query. When you enter new records into the form they are recorded into the table. From that point you can add criteria to a query to return and/or filter records in any way they are needed.

 

[aingram]

I have a master table setup just now for over 2000 records (each record has about 20 fields), which a form (through a query) picks up, i get that any change in the form will change the master table

Im looking to make an extra tab in the same form that will have the ability to tranfer the id and a date entered (at a click command) in to a sepeate table and not the master one

So that i will have a table with alot of ids and dates in it.

 

[CEH]

Read up on "normalization" You should not have two tables with the same fields. I don't know the purpose of your DB, but I think what your trying to do could be achieved in another way..... For example... If a Yes/No box was used to identify a certian date and ID combo... Then a query of all "Yes" or "No" would return the desired records.