I create a form with my table now I want append last or current record should be append to another table how should write the queries or click event code for command button

Mohamed Mohiddin
Officer

__________________
Mohamed Mohiddin
Officer

Can you clarify? It sounds like when a record is added or changed in one bound form, you want to append that new or changed information to another unbound table. Is that correct?


mmcdonal

Hi mmcdonal
Thanks for response actual In my form there are four bound field like txtstno, txtname, txtpay, txtloan is there in my form when I add new records I want to add another table like tblLoan Now I want when I click the command button I want add all filed above to be added in tblloan



Mohamed Mohiddin
Officer

Why do you need to duplicate this data in a second table? Perhaps a query would work instead.

Please let me know how you would like to proceed.


mmcdonal

Once again thank you
Actually txtloan field is not in main table in txtloan some function are there like

Public Function mmela(ByVal mela As Double) As Double
Dim mb As Double
Dim ml As Double
mb = Me.pay
ml = mb * 100
mcl = 800000
mela = ml
If mela > 800000 Then
mmela = 800000
ElseIf mela <= 800000 Then
mmela = ml
End If
End Function
So I want append all above field records in another table


Mohamed Mohiddin
Officer

You need to create a new field in the table where you want this value stored. Let's call it "Loan"

Then copy this code that calculates the value to the Before Insert AND Before Update events on the form.

Add this line to the end of the code on both of these events:

Me.Loan = mmela()

That should work.

mmcdonal

Ok but I want only one recordset to append to my another table tblLoan eg.out of 10 i want append 9th one to be append

Mohamed Mohiddin
Officer

I'm sorry, now I am lost. How do you choose the record that gets appended?

mmcdonal