I just read a great tutorial on Martin Greens terrific website on how to
create forms that behave as a Parameter Query dialog box but with the
benefit of having a drop down listing to select from. It can be found here.

http://www.fontstuff.com/access/acctut08.htm

I have gone through the article word for word twice and created the
database, forms, etc in Access but I cannot get it to work properly. I
emailed Martin looking for guidance but he hasn't responded (must be too
busy with paying customers). Has anyone tried this exercise and got it to
work properly? I'm using Access 2003 here at work. If anyone has gotten this
to work and could provide me with the file I would be forever grateful.

Roger Tregelles
Quality Engineer

Can you be more specific about what isn't working? Were you able to create
the query and use the parameter form to provide the query parameters?
Regarding allowing null values, I'm not sure I see the point of OR LIKE. I
think I would have just used OR. Again, details needed.

"Roger Tregelles" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>I just read a great tutorial on Martin Greens terrific website on how to
> create forms that behave as a Parameter Query dialog box but with the
> benefit of having a drop down listing to select from. It can be found
> here.
>
> http://www.fontstuff.com/access/acctut08.htm
>
> I have gone through the article word for word twice and created the
> database, forms, etc in Access but I cannot get it to work properly. I
> emailed Martin looking for guidance but he hasn't responded (must be too
> busy with paying customers). Has anyone tried this exercise and got it to
> work properly? I'm using Access 2003 here at work. If anyone has gotten
> this
> to work and could provide me with the file I would be forever grateful.
>
> Roger Tregelles
> Quality Engineer
>
>

Bruce,

I finally got it to work as described in the article. However when I tried
to implement it into one of my databases it comes up with blank results. I
think the problem is that the field I'm searching on is a child record and
that table has a ID number that is the primary key which is not what I want
to search on. I'll just have to stick with the old Parameter query for now I
suppose as I have this tied to a report and I don't see a way to use this
technique which yields only datasheet query view results. Thanks for the
help anyway.

Roger Tregelles
Quality Engineer

I would have stayed out of the conversation if I had known you need to use
the parameter on a child record. I believe it can be done, but I don't know
the technique. If you can get the parameter form to work with a parent
record (even though that's not what you want, it will let you test the
system), then you can post back with a question about using a parameter on
the child records. You have already demonstrated a willingness to seek
answers on your own, which tends to encourage people here to be more
helpful, I think.

"Roger Tregelles" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Bruce,
>
> I finally got it to work as described in the article. However when I tried
> to implement it into one of my databases it comes up with blank results. I
> think the problem is that the field I'm searching on is a child record and
> that table has a ID number that is the primary key which is not what I
> want
> to search on. I'll just have to stick with the old Parameter query for now
> I
> suppose as I have this tied to a report and I don't see a way to use this
> technique which yields only datasheet query view results. Thanks for the
> help anyway.
>
> Roger Tregelles
> Quality Engineer
>
>