Filtering by buttons

[adrisoares]

Created a database for U-Bolts. The columns that shall be filtered are "Type", "Diameter", "Height" and "Opening". Created a form and to narrow the items to be shown I placed a Slide with drawings of the diferent types of U-Bolts. On top of that slide and on each drawing I placed a transparent Command Button. By pressing each of the buttons I want the database to be filtered to the chosen "Type", "Diameter" in ascending order, "Height" in ascending order and "Opening" in ascending order. Will anyone tell me what the comand code should look like. TIA . Adriano - Portugal

[June7]

The form RowSource can be a query that has ORDER BY clause or can set those sort criteria in the OrderBy property of the form.

Here is one method to filter the form http://datapigtechnologies.com/flash...tomfilter.html

What is a 'Slide'?

[adrisoares]

[QUOTE=What is a 'Slide'?[/QUOTE]

A Slide is a foto *.jpeg
It can be seen on left down of the Form I attach here.

I can't use a query. The "slide" of the different types is already defined. The right photo is an attachement that will depend on the type , in this case "A1" as shown on the top right. At the moment if I scroll down by the Item Code (Código) it will show every Item from every type. I can use the toolbar to select the type I want, but I want to make the "grouping" using a command button.

[June7]

What do you mean - 'can't use a query'? If you want to 'filter' then a query is involved. What do you mean by 'scroll down'? I don't see scroll bars or comboboxes.

How is the large image on the right generated? Is this with an Image control? Are these images embedded in an attachment field in table? If you want to provide db for analysis, follow instructions at bottom of my post.

I just don't understand what behavior you want form to accomplish.

[adrisoares]

By Scroll down I mean I can place the mouse cursor in one of the text boxes and with Keys PgDn and PgUp go to next values. Those images on the right are images embedded in an attach. field on the table. I can use the tool FIND on the toolbar to find a value for consultation. This database and form will be "lent" to some major customers and they can look for example for a type S1 and then a rod diameter 20 and so one. By clicking on the transparent buttons already on the picture of types on the left side I want only the items within a certain type to be shawn. If I chose Type R1, I will only have access to all the items in that type. Sorry if it is getting hard to pass the ideas, but as portuguese trying to express myself in english, I just try my best . :-)
After repairing/compacting and zipping the file it still is 5,8 Mb anf the upload failed.

[June7]

Large size probably because of the embedded images in attachment field. Could you make a copy and eliminate some records until size is manageable? And/Or provide just objects relevant to this issue. Alternative is upload to a fileshare site such as Box.com and post link to the file.

You want to filter the records according to the button clicked on the leftimage, which is the Type? Where is criteria for diameter entered?

This could involve some code that would set filter property of the form or perhaps to open another form filtered to the desired data.

I really need to see the db to get better understanding.