Open a form in context from a multiple item form

[Jools Southcote]

I have a multiple item form based on a query. It is a list of customers
along with the total invoice amount. Each customer is identified by a
category AND the customer name. I have added a button at the end of each
line to open a form that allows me to edit the customer and also display a
list of invlices in a subform.

No matter what I try, the form I'm trying to open always displays the same
customer record. It will not display the customer of the row in which I
clicked on the button.

I'm sure that this can't be that difficult, I just can't crack it.

I am a beginner at VB and I'm using Access 2007.

 

[Beetle]

Sounds like you're missing the link criteria. post the code behind your button.

 

[Jools Southcote]

I'm using an embedded macro, there is only one action (OpenForm) and it has
the following arguments:

Customer, Form, , "[CustomerCategory]=" & "'" & [CustomerCategory] & "'" And
"[Customer]=" & "'" & [Customer] & "'", , Normal