ADD Record

[abusaif]

Hi there,



I have two forms form (1) is Item Master and its fields are ItemID, Description, UoM. Form (2) is Transaction form its fields are ID, ItemID & Qty.

I have Hyperlinked the ItemID field in Item Master by clicking it opens the Transaction Form. At the click event of ItemID when it opens the Transaction Form I want to add a code which could copy the ItemID from Item Master to Transaction form and set focus on Qty.

Is It Possible?

[burrina]

Isn't ItemID a Primary Key? If so why would want to do this? Is Transaction a subform? If so are they not linked?

Me![subformnamehere].SetFocus
Me![subformnamehere]!controlnamehere.SetFocus

HTH

[ranman256]

You mean add a new transaction record?
(this can be done in a single form )

The item master and a sub form holding the transactions. Then all you do to add a new record is type at the bottom row (like a spreadsheet)
IT would fill in the itemID.

[abusaif]

thanks for reply.

Yes ItemID is a Primary Key in frmItemMaster, where as frmTransaction is an other form.

Actually what I want is when I receive Something so in frmItemMaster I will click on ItemID so it will open frmTransaction copying ItemID to frmTransaction, so I will only enter the Qty.

I reached upto this level....

Private Sub ItemID_Click()
Dim stDocName As String

stDocName = "frmTransaction"

DoCmd.OpenForm stDocName
DoCmd.GoToRecord , , acNewRec

End Sub

[abusaif]

Thanks a TON "ranman256"

You gave me a nice clue, I really appreciate this but actually I was looking for a code which could copy a value from one form to an other.

Any how this will also work perfect.

Once again thanks a lot.