User Profile
kmyriam
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Search box not working on a continuous form
I'm new to MS Access. I'm having an issue with one of my search boxes. I have a table containing historical data for my team. The table has 12 fields. I've created a query from the table with all fields. I've also created a continuous form pulling data from the query. On the form I've added 2 search boxes. One box for an ID field and the other for a name field from the query. I've added 2 criteria to the query under each field linking to the corresponding search box(for the ID, [FORMS]![QRYHISTORICAL]![IDSEARCH]; for the name, LIKE "*" & [FORMS]![QRYHISTORICAL]![NAMESEARCH] & "*";. I've added a Vba code to requery the form. The ID search box is returning data from the search but the name search box isn't any result. What can be the cause of my issue?1.1KViews0likes4Comments
Recent Blog Articles
No content to show