Printing a report based on one row of data

[MEEMeyer]

I have two tables -- one is customer and the other proposal. I have a query (join) that matches customers with proposals based on customer_id in both tables. I display in a multi row form the proposals and want to select ONE proposal to print.



How do I select ONLY the join based on the proposal record which has the customer_id? I only want the ONE proposal and it's customer information to print.

[pbaldy]

See if this technique works, using the proposal ID:

BaldyWeb wherecondition

[MEEMeyer]

That all sounds wonderful, but I am NOT a seasoned MSAccess developer and certainly not a programmer. I would need detailed instructions.....

Mike

[pbaldy]

Where exactly are you hung up?

[MEEMeyer]

Well -- for one thing, where do I start?

[pbaldy]

I guess here:

http://www.baldyweb.com/FirstVBA.htm

[MEEMeyer]

OK, I have entered the following code in VBA:

"Private Sub Form_DblClick(Cancel As Integer)
DoCmd.OpenReport "Proposal to Print", , , "FieldName = " & Me.ControlName
End Sub"

I have created a form called "Proposal to Print"

Questions.
How do I enter a field name i.e. what name do I use?
What is Me.ControlName?

I apologize for being so lame, but this is something I've never done in Access.

Mike

[MEEMeyer]

Also, what do I click on during execution?

[pbaldy]

Based on your original description, I would likely use the double click event of the textbox containing the proposal ID, or perhaps the click event of a button. I think either is more intuitive for the user. The double click event of the form itself would probably be problematic.

You would replace "FieldName" with the name of your proposal ID field, and "ControlName" with the name of the textbox containing that field on the form.