How to get the data from a form into another from.

[arunakumari02]

How to get the data from a form into another from.

I have a form "changeSecreen". I have name, ID, owner and command buttons. When I click on command button the other form "moveScreen" should open with the details of the name, Id and owner from the changeScreen.

Can anyone help me in how to fetch the data from oneform to another forms.

Private Function openScreen(txtProjectID As Integer)
    DoCmd.OpenForm "frmMoveSreen", , , "[ID]= " & txtProjectID
          
End Function

 

[rainman89]

this can be done with the button wizard. try that out!

 

[arunakumari02]

They are rectangular bars not buttons.

Any help is appreciated

 

[rainman89]

They are rectangular bars not buttons.

Any help is appreciated

I have no idea what this means???

 

[AirForceCoder]

umm y dont you just use me!txtfield?

ok you can do something like this?

cmdfillinhisform_click()
docmd.openform "movewindow"
with frm
.formfields("bookmark/name of text box goes here").result = me!"name of txtbox on your preveous form"
...
end with
frm.movewindow.visible = true
end sub