Microsoft Access

[tpitman]

Hi, I'm trying to set up 2 parameters in a query, whereby the parameters are specified by fields in a form

i.e.
forms!SearchForm!bicycle
forms!SearchForm!FrameColour

I would like know if it's possible to set it up so that if the user specifies only the bicycle, then all bicycles of a specified make are shown, but if they fill the colour field, then obviously only bicycles of that colour are shown.

At the moment I am only able to get it to work if both fields are entered.

[highrock]

you could have a seperate query for each. one for the bicycles and one for colors. probably not what u want to do but maybe it'll help a little.

[cbuddha42]

ya just make default value *

[cbuddha42]

doh just rembered vb crashes on * - use moduel and IsNull to find which fields are filled in and then run query based on that information