Help with Buttons opening the correct report

[abakhaus]

I was tasked with revamping my companies Access Data base for part specs. I am having an issue figuring out how to make it all gel together. Below is how I would like it to function.


A Form for Each Customer. Customer ID will be the only unique field for each Customer form. Each Customer form will have the same 6 buttons.

When a button is clicked I would like to spit out a report based on the Customer ID that is on that form and the button Caption.

For Example Customer A Form is open. Button 1(Name) is clicked. Report is opened from the main table with only data for Customer A and Button 1 (Name)

I appreciate any help you can give.

[ranman256]

You don't need all those forms. 1 customer form can show all the customers or 1 customer.
otherwise you need to program N forms.
and how many report buttons does 1 form have? Just 1?
but
to report on the shown record, on button click,
Docmd.openreport "myReport",acViewPreview,,"[id]=" & txtBoxID

[abakhaus]

Thanks! Appreciate the help. Can you tell me what Combo box field stores the value that is selected from the drop down? Trying to use the criteria in a Query and I can't get it to work.

[abakhaus]

In my Criteria Box in the Query I have [Forms]![Cookbook]![CPNPCombo] However it isnt pulling the combobox value to fill in the query. Please help.

[ssanfu]

You could post your dB for analysis..... (do a "Compact & Repair", then Zip it)

[ranman256]

The query would pull all customers by name,with the ID hidden in the 1st column.
user picks by name,but the comb stores the ID.