Help with editing a record within a subform 1

[Ezeasy]

I have a database with requests from customers. When a new request is needed I have it that you view the customers make sure they are in the table in form (Schcustomer) from that point you select which customer the request is for by clicking a button next to record that brings up all information about the customer with a form(Vcustomer) and a subform (Vrequest_subform) shows all requests for customer. What I need is a way to open my requests (frmRequests) from here with any request I want to select is this possible? And how would this be done. I’m unable to add a button to the subform next to the record.

Thanks for any help………..

 

[Trendsetter]

Why not use the Double_Click event of the subform records??
DoCmd.OpenForm "frmRequest" ,RequestID=Me.RequestID

This opens the form and links the data in the new form with the record you have selected in the subform

 

[Ezeasy]

Trendsetter,
Thanks this is what I'm looking for the only thing is all my request records load into my form I just need the one I Double_Click on any suggests.
Thanks Ez.

 

[Trendsetter]

In the command string to open the form you need to specify which record you have selected - this sysntax should do it:

DoCmd.OpenForm "frmRequest",,,RequestID=Me.RequestID

 

[Ezeasy]

Trendsetter,
That's extactly what I needed;
Thank you very much