Aug 26 2023 04:28 AM
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?
Aug 26 2023 07:00 AM
Aug 26 2023 12:35 PM
I did put each criteria under its column. I've tried running only the name and it didn't work.
Aug 27 2023 08:00 AM
I was able to use VBA code instead of adding criteria to the query. The boxes are working now. Thank you for your help
Aug 27 2023 08:01 AM