Even Microsoft Couldn't Solve This One...Can Anyone?

[italianfinancier]

Hi, I just got off the phone with Microsoft Technical Support and the tech said he didn't know how to get my issue solved. All I want to do is have a form that a user enters a customer number into and from that a report generates showing just the information about that customer. I have attached detailed screen shots for your review if you are kind enough to take on this challenge and possibly upstage Microsoft . Please provide detail in your response, as I am somewhat new to Access.

[ajetrumpet]

of course this is possible. I sure hope you didn't pay the 50 bucks required to talk to someone on the phone. MS is the last place you look for help on Access. Unfortunately that's the way it is!

your request is simple. all you need to do is run an OPENREPORT command and put an expression into the FILTER argument. It's no more complicated than that.

[June7]

Outrageous! Better off getting some good reference books than seeking help from MS tech support (now I know why I never will). This is elementary coding. Even a macro could do this. In VBA, perhaps in a button click event, the syntax would be like:
DoCmd.OpenReport "reportname", , "fieldname=" & Me.controlname
Not sure how it would look in a macro, I don't use them. Reference to the control would probably be like: Forms!formname!controlname

The WHERE argument can have multiple criteria.

Of course, the report must have a RecordSource that includes the field(s) the filter criteria will be applied to.

Your query is incomplete. You need to join the tables on the primary/foreign keys. Looks like customer number in each table. Be sure to get the jointype correct for each link. Quite possible this query will be too complex. If you had established relationships Access would have made these joins when the tables added to the query designer.

Access Help should have some guidance. And like I said, some good reference books could be useful.