open a form

[jamesT]

hi

I have a sub form with several records (invoice Numbers) by the side of each record i have a button (Details)

I want to be able to press this button in the sub form and it opens another form /subform with the selected invoice number and details of that invoice

Not sure how to do this any help would be great

Thanks

 

[Jack Cowley]

In the On Click event of the button choose [Event Procedure] and put this line of code in the subroutine changing names as necessary:

DoCmd.OpenForm "FormNameHere", , , "[UniqueRecordID] = " & Me.NameOfControlWithUniqueID

hth,
Jack