search records on subform

[ultra5219]

hi guys
im creating search form on access to search any records on Subject table. inside of subject table contain subject id, subject name and group class.
the question is can i create 1 search box to search any these three key words on subforms??


i got trouble on programming error..method or data member not found error..
has anyone know how to fix this? maybe someone can fix the search error problem.. even i clear search still not working..
thanks..

[qa12dx]

like so?

some suggestions;
i like to use filter as it will only show results that match the criteria.
ur forms, subfrms, controls could be better named. read this http://www.access-programmers.co.uk/...d.php?t=225837

[ultra5219]

well.. i try and test it..it works perfectly i prefer this method... if advance method, it take long time to edit some codes.
Oh yeah.. one more thing, since i test the search form works properly, lets say if i search any keywords but not match found, Error message pop up on screen says " Search not found. Please try again" is it possible to do that?

Thanks

[qa12dx]

updated the db. i thought u'd ask that
anyway i needed to figure it out too. it was quick. that's why i LOVE access

change the message to what ever you need.

[ultra5219]

OMG...gee.. thanks alot it works perfectly!! OMG.. im just beginner access.. since u LOVE access..i think u're an expert!!... 100 ++ points for u.. LOL

[qa12dx]

lol! thanx