form with search function

[Mike Hughes]

When the user clicks on the SEARCH button on the main form a second form opens. The user then selects a column name from the drop down box and then enters what they want to find in that column. Example would be I search on the check number and and ask for check number 1245. Even though that check number is in the DB the search returns nothing. Can someone give the DB a look and let me know what is wrong. Thanks Mike

 

[MarkK]

A problem I ran into is the the Format property of the textbox txtSearchString was 'Short Date' so my check number value failed validation because it wasn't a date. If I removed that format it worked.

 

[Mike Hughes]

That was all it was. Thanks for the help. Mike