How to move current record from a form to another form in access?

Question

I would lượt thích to tát move the current record meaning all the field for the current person in that sườn to tát another sườn which is one table to tát another table via forms. Using one command button. How can I vì thế that?

I am thinking to tát use add và delete action to tát put in one button as it look lượt thích another way of moving too. But I have no ideas how to tát put only one record which is from the current person in that sườn. something lượt thích "current session"

In access.

asked May 15, 2013 at 7:01

3

matzonematzone 5,7213 gold badges18 silver badges20 bronze badges · Accepted Answer

Basic step ..

Assume that you have Datagrid control named dgvMember in Form1 and dgvNonMember in Form2

You can create button named btnMoved that have click sự kiện lượt thích this ..

Private Sub btnMoved_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnMoved.Click

//retrieve currentrow info from dgvMember -- all column as datagrid.row

//put the retrieved row to tát dgvNonMember -- directly to tát table/datasource

//it's now safe to tát delete selected row in dgvMember

End Sub