How to link a Report to a Form

[alextol]

I am new to Access. I am using 2010 version. Can some one please please explain to me how to generate a report after I type in Client # into the form. I have create form, query and a report. I just need to link them together. Which button should I use? I want the report generate onenter command. How do I do this? Please help!

[June7]

Options:

1. VBA (I use only VBA but macro has equivalent structure): DoCmd.OpenReport "report name", , , "ClientID=" & Me.textboxClientID
Put code in button Click event or textbox AfterUpdate event

2. http://datapigtechnologies.com/flash...mtoreport.html


BTW, should not use spaces or special characters/punctuation (underscore is exception) in names, nor reserved words as names. Better would be ClientNum, ClientID, Client_Num, Client_ID.

[alextol]

Thanks, June7! This was very helpful. I have another question. How do I get rid of duplicate entries on my report? My report is looking like this now:

client_no	name	start_date	term_date	NAICS
31M	Analysis Team	8/26/1997		541511
31M	Analysis Team	8/26/1997		541511
31M	Analysis Team	8/26/1997		541511

The report is pulling data from query that doesn't have duplicates. I am not sure what causing my report to duplicate the data...

[June7]

If report is based on query object, I don't know why you see something different in report. If you want to provde db for analysis, follow instructions at bottom of my post.

[alextol]

I rebuit the Report and it works fine now. I must have mess it up earlier. But I have another problem. When I run report for a particular client (I have a combobox where you can type in the client name). I get the whole report starting with the 1st page for about 4,000 clients. How do I make the form to give me info just for the client I asked for?

[June7]

Use one of the options described in post 2.

[alextol]

I added ..."FieldName='" & Me.ControlName & "'" to the formula and it worked. Thank you. I appreciate your help!