query button

[jgeneie]

hi all

I have created a macro to display the output in a report format - which is to say, a OK button was created using a marco. Is there other better methods.

* because I have other records to display in the report. eg. address, email, tele. but whenever i click the ok button, it pops out the "enter parameter value" for address, email and tele. which i dont intend to use as a search criteria.

please assist
thanks

 

[Nilgni]

You question is hard to understand, but here is a shot at what you are looking for..
When you open a report (via a macro or other directions) it searches for the information for each field that you have created. If it cannot find the field it will ask you for the value that you want to display. This will happen even if you don't use a macro to create it. Try to open the report on its own and see if it will open cleanly. If the report is based on a query, make sure all of the fields are listed. If this doesn't solve your question then try to rephrase your question a little clearer and we can try to help you again. TIP:If you want to open the report from a form try using the COMMAND Button with the wizard on..it will do all of the Visual Basic code for you and eliminate the use for a macro to view the report. Hope this was helpful

 

[jgeneie]

hi SkyChief (Instructor),
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"?

 

[paron]

I suppose that you are entering your search (filter)criteria in a form, and then producing the report when the user clicks OK. It sounds like the query that runs when you click OK has more criteria than you want to enter. Try going into the query that the report is based on and eliminating all criteria except customername, companyname, and country.

Ron

 

[Nilgni]

Here is what I thing you want to happen:
1.You want to pull a value from the combo box
2.The information related to that person should fill in the boxes below.

Example: Bob, 1 Anystreet, Anytown, USA
Solution
Create the combo box with all of the fields selected. (TIP: If you don't want the user to see the other fields when they pull the box, decrease the size of the fields under the format tab)
1.Make unbound boxes for all fields except the combo box
2.In the unbound boxes enter this for the control source

=comboboxname.column(x)

X= the column where the other information is stored.

If you put this: =comboboxname.column(2) you would see the address for the combo box in the text box each time you updated the combo box

 

[Nilgni]

Here is what I think you want to happen:
1.You want to pull a value from the combo box
2.The information related to that person should fill in the boxes below.

Example: Bob, 1 Anystreet, Anytown, USA
Solution
Re-create the combo box with all of the fields selected. (TIP: If you don't want the user to see the other fields when they pull the box, decrease the size of the fields under the format tab)
1.Make unbound boxes for all fields except the combo box
2.In the unbound boxes enter this for the control source

=comboboxname.column(x)

X= the column where the other information is stored.

If you put this: =comboboxname.column(2) you would see the address for the combo box in the text box each time you updated the combo box.

If this isn't clear there are many articles that cover this exercise.