Dear All,
Say for example, I have a Table named 'Table1' contains fields, ID (as primary), MDate, PersonName, PersonJob. Another table named 'Table2' contains ID (as primary), MDate, PersonName, PersonAddress.
I have a Form contains a ComboBox named 'cmbbox1' and have TextBoxes named 'txtbox1' and 'txtbox2'. I have managed to fill the 'MDate' field values from 'Table1'. I want to fill the selected 'MDate' corresponding value of PersonJob...

Re: Adding records to the MSAccess table with recordset (using For...Next loop)

Thanks NeoPa for your kind reply. I have amended accordingly.

Thanks ADezii for your kind amended code too. Brilliant!. The code is working fine.

Thanks to all too those who replied.

I wanted to attach the file for reference. But I dont know how to attach here. So I inserted the code here.... In the following...

Re: Adding records to the MSAccess table with recordset (using For...Next loop)

Thanks Jerry for your kind reply.

First of all, there is one error in my posting. That is instead of "!'XXXXXXXX X'= Me("txtF" & I)", I wrote !'XXXXXXXXX'= Me("txtCh" & I).

Sorry, your guess is wrong. It is not copied, probably I have asked this question in some other forum which you could...

Dear All,

This query is related to MSAccess-Forms-VBA coding to adding new records in to a table using recordset.

For example, I have a table named as 'Table1' with fields F1, F2, F3, F4. In the Form, I have four TextBoxs named as txtF1, txtF2, txtF3, txtF4. I have a Command button named as 'Command19'.

I would like to insert a record into the 'Table1'. I want to use a loop to add the values from TextBoxes...