Need hlep on Search Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lostboyca - 05 Mar 2008 00:30 GMT

I am having issues on my search page. I cannot seem to get certai
fields to search correct.

The fields I am having problems are listed below...

1) ID = This Field should be coming from Qualification Area FORM
2) Vers = This Field should be coming from Qualification Area FORM
3) % Complete = This field should be comeing from Qualification Are
FORM
4) Plus when I have my form all blank with no informaiton it shoul
show all records on the subform but does not.

For some reason I cannot attach the file to this thread please go t
http://www.diversityrus.com/Qualification.zip to get the database

Hope someone can help....

Thanks in advance....

Lostboyc

--
lostboyca

Reply to this Message

Allen Browne - 05 Mar 2008 02:06 GMT

We cannot open your database and debug it for you.

What we can do is provide some examples so you can see how it's done, and do
if for yourself.

Here's one you can download:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I am having issues on my search page. I cannot seem to get certain
> fields to search correct.
[quoted text clipped - 7 lines]
> 4) Plus when I have my form all blank with no informaiton it should
> show all records on the subform but does not.

Reply to this Message

lostboyca - 05 Mar 2008 21:08 GMT

Allen Browne;2656760 Wrote:

> We cannot open your database and debug it for you.
>
[quoted text clipped - 18 lines]
> 4) Plus when I have my form all blank with no informaiton it should
> show all records on the subform but does not. -

Still no luck cannot get it to work with my database :(

Signature

lostboyca

Reply to this Message

John W. Vinson - 05 Mar 2008 22:46 GMT

>Still no luck cannot get it to work with my database :(

"Doctor, I don't feel good. What's wrong with me and what should I take?"

We do our best, but it's impossible to help if we don't have information.

What did you actually put into your database?
In what way did it not work?

YOU can see your screen. We cannot. We'll be glad to help you, but you will
need to help us to do so!

Signature

John W. Vinson [MVP]

Reply to this Message