Using data from on table & storing in another using forms

[Guest]

Hi,
Bit of a beginner, but hope someone can help!
I have a form (Form1) for which the record source is set as a table
(Table1), i have comand buttons on the form which i use to put numbers into a
text box, then i click my 'find' button and the information relating to the
number in the text box is displayed in other text boxes on the form.
Eg, my 'Table1' has 2 colums one for product and one for barcode. I enter
the barcode into the text box on my form and the product is displayed in
another textbox. (sorry if this is getting confusing)!
What i want to do is:
Using one form, find data from table 1, add other data into other text boxes
on the form using comand buttons, and then store all of the data on the form
in table 2.

Any help would be great - Iv' had too many late nights trying different code
and its getting frustrating!!

Thank you in advance.
Nick

 

[Jeff Boyce]

Nick

I may be missing something...

If you already have the data in Table1, why do you believe you need a copy
of it in Table2?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi Jeff,
Sorry if i didnt explain properly.......
Iv got a table which has a list of products and their barcodes in it, users
of the database will only see the form. They will scan a barcode on a
product and the number comes up in a text box on the form, they will then
press the 'find' button on the form, and the product name will appear in
another text box.
This all works fine, however i want users to be able to input further info
(such as date of manufacture & quantity) into the same form using comand
buttons which i have set up. Then i want all of this info to be stored in
another table.
So, basically, table 1 will be a fixed table which info is taken from, but
table 2 will have info inserted into it.

I hope this makes sence - as i said, im just a beginner, so hope you can
help.

Many thanks
Nick

 

[Jeff Boyce]

Nick

It all starts with the data ... please post back a description of the two
tables (i.e., what data elements do you have in each?).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff,

Table1 - this will be my 'reference' data table and have: Barcode, Product
and Weight in the table - 3 colums with the relivant info manually inputted
into each column.
Table2 - this will have: Barcode, Product, Weight, but also: date, time,
quantity, and an 'autonumber' automatically generated when a new record is
added.

When a barcode is inputted into my form, the Product and Weight will
automatically appear in other text boxes, as this data will be taken from
Table1. Then the user will input (into other text boxes) the Date, Time and
Quantity and the record will be allocated an 'autonumber' when the 'add new
record' comand button is clicked.
Then i want all of this info to be stored as a new record in Table2. I dont
want to add records to Table1 as this is my 'product reference' table.

Hope this helps you help me!

Thanks so much.
Nick