query button HELP!

[jgeneie]

hi all,

okie this is a tough one to explain....becoz i am still very new to this access....

first i have a table that store a list of customer and their profiles.

secondly i have created a search form consist of a few textboxes. i have eg. three textboxes for customername, companyname and country. so lets say i have key in the criteria for all the three textboxes, bob, bob co. and singapore. ideally when i click "OK" in the form, bob's profile like his address, telephone no., emailadd etc will be displayed in the report. but currently, when i click "OK" it prompts me to "enter parameter value" for teleno, emailadd, address.

how do i elimiate the "enter parameter value"?

pls assist

 

[jebry]

Hi!

To give you an exact answer we would need to see the code (SQL) of the query that the report is based on. Evidently when Access runs the query when the report opens it can't identify some parameters used for criteria. Please post the code and we can give you a better idea.

Jeff Bridgham
bridgham@purdue.edu

 

[paron]

See thread181-216483 for the same question by the same author. We can combine our efforts!!