Update Table From Form?

J

Jason Gyetko

I have a form that has two bound text boxes and three unbound text boxes.
Using the example below, Field1 and Field2 are bound to a table:

FORM:
frmField1 frmField2 frmField3 frmField4 frmField5
---------- ---------- ---------- ---------- ----------
Data1 Data2 Data3 Data4 Data5

Given the data in the form above, I need it to update my table as so (one
record for each unbound field):

TABLE:
tblField1 tblField2 tblField3
--------- --------- ---------
Data1 Data2 Data3
Data1 Data2 Data4
Data1 Data2 Data5

Does anyone know the best way to accomplish this? Would it be easier if
they were all unbound and just write 3 new records once the data entry is
complete?

Also, with the unbound fields, I enter the data in the first record, then
move on to the next, but when I enter the values for the second record, they
change the values for the first record. Does anyone know how I can specify
different values for each record?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access form continuous 1
consolidation data in one row 2
Transposing 2
Select to reference an other record or row 1
How to select values in sequence order? 4
Creating a Search using a combo box and then creating a report. 4
Crosstab leaves Blank fields 2
Update Set Values 3

Top