Forms not showing records

[Guest]

I am currently making a database that is giving me a large amount of grief.

First of all, my superior wanted to be able to search records (like Google
searches) for keywords. I didn't know of a way to make this happen, so I
decided to make a table for keyword identification (tabKW) and a table for
assigning keywords to the records (tabKWAssign). On the form itself
(frmDataEntry), a user will type in a word, click add, and a new record is
added to tabKW, then a new record is added to tabKWAssign. I have a search
feature at the bottom so that the user might then filter the records by the
keyword. My problem is now two-fold.

First of all, now my form is not displaying ANY of the records (even before
I search by keyword); second of all, the search function does not work at
all.

I am not sure what to do about this, but I will be leaving this company soon
and would hate to leave them with a half-finished database!

Thank you for your time

 

[Guest]

You are making it too complicated. In the query for the form use criteria
like this --
Like "*" & [Forms]![YourFormName]![YourSearchTextBox] & "*"

 

[Guest]

Karl,

Thank you SO SO SO much! Honestly, that was one full week of trying things
out that was completely resolved by your simple answer! I have no computer
programming background really and have no idea about these things! My boss,
and my job, and I all thank you!!!!!!

You are making it too complicated. In the query for the form use criteria
like this --
Like "*" & [Forms]![YourFormName]![YourSearchTextBox] & "*"

--
KARL DEWEY
Build a little - Test a little

I am currently making a database that is giving me a large amount of grief.

First of all, my superior wanted to be able to search records (like Google
searches) for keywords. I didn't know of a way to make this happen, so I
decided to make a table for keyword identification (tabKW) and a table for
assigning keywords to the records (tabKWAssign). On the form itself
(frmDataEntry), a user will type in a word, click add, and a new record is
added to tabKW, then a new record is added to tabKWAssign. I have a search
feature at the bottom so that the user might then filter the records by the
keyword. My problem is now two-fold.

First of all, now my form is not displaying ANY of the records (even before
I search by keyword); second of all, the search function does not work at
all.

I am not sure what to do about this, but I will be leaving this company soon
and would hate to leave them with a half-finished database!

Thank you for your time