Link to home
Start Free TrialLog in
Avatar of surah79
surah79

asked on

Access Database Search form Not Working

Hi Guys

As attached. In this database I am trying to create a search form Called "Copy of Application Summary by 1000" I had added a new field Called "Deal Work Flow" as soon as I select the options in it the search form doesn't work.

Any help will be appreciated.

thanks


Edit... Attachment removed due to privacy information contained therein.
IrogSinta
Topic Advisor
SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of surah79
surah79

ASKER

As attached a new copy with all the test information. In this database I am trying to create a search form Called " Application Summary by 1000" I had added a new field Called "Deal Work Flow" as soon as I select the options in it the search form doesn't work.

It should populate the form with critieria selected in the Deal Work Flow combo box
Any help will be appreciated.If I don't select anything then it should default to show all the records same as the When we select "ANY" in the  Decision Status box.


thanks
versionnew.mdb
Avatar of surah79

ASKER

Hi Ron

It working now but its giving the ID instead of the Name there. Do I have to make a change in the table to get workflow status instead of workflow ID.

User generated image
Thanks a lot
Did you remove the Lookup Field from the table?  The advice on Lookup Fields was not to fix your current problem, rather, it was to guide you in your future database designs.  Right now your table has quite a number of Lookup Fields so changing just one is of no value.  

Go ahead and put back your Lookup Field in this instance.  In the next database you attempt to create, try to learn first about relational database design.

Ron
Avatar of surah79

ASKER

No I didn't remove the lookup field from the table.