Click field in Subform to open another form filtered by that field's value

[gskinstad]

Hi All

Sorry to bother everyone with a newbie question, but I could really do with some help.

I am creating a database which tracks outstanding invoices by customer. I have a query which filters for only unpaid invoices, and this is displayed as a subform in a form which has the customer name and account number on it. It enables me to see all outstanding invoices by customer.

I have another form in which each record is an individual invoice, and it has a subform within it which tracks "Chasers". So everytime payment is chased, a record is entered to keep track of when the invoice was traced and what the outcome was.

What I would like to do is double click the invoice number on the first form, and for it to then open the other form filtered by that invoice number.

I typed in the following code

DoCmd.Openform "frm_ProformaInvoices",,,"Sales_order =" & Me.Sales_order

All I get when I run it is a pop up box asking for a value

Where am I going wrong?



Appreciate any advice

[NTC]

are you double clicking on a record in the main form, or in the subform?

if in the subform then use the full syntax for the control [Sales_order] with main form object, subform object, control

hope this helps.

[gskinstad]

Thanks - its I am double clicking in the subform

Can you give me an example of what the syntax would be?

The subform name is frm_proformainvoicesunpaid

[pbaldy]

The parameter prompt implies that one of the names is wrong. Does your field really have an underscore, or might it have a space? Double check the spelling of everything.

[gskinstad]

Right, I have changed the syntax to include thecontrol [Sales_order] with main form object, subform object, control which looks as follows

Private Sub Sales_Order_DblClick(Cancel As Integer)


DoCmd.OpenForm "frm_ProformaInvoices", , , "[Sales order] = " & Me.Form![frm_ProformasbyCustomers].Form![qry_ProformaInvoicesUnpaid subform1].[Sales order]



End Sub


However I now get the following error message





Please excuse the sloppy naming - I am going to clean this up

[pbaldy]

You don't want the "Me." in there:

Forms Refer to Form and Subform properties and controls

[gskinstad]

Thanks - however no matter what I do, I still get the following message

"The expression On DBl CLick you entered as the event proprty setting produced the following error: A problem occured while Customer Database was communicating with the OLE server or ActiveX control"

No idea what to do now

:-(

[NTC]

Forms!MainFormName.SubFormName.Form!ControlName

where ever it says 'name' - you use your actual object name instead the rest is literal. be sure to use [ ] if your object names are not 1 word.