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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
No I didn't remove the lookup field from the table.
ASKER
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