mardi 24 mars 2015

Search and filter in MS Access forms

Background: I have a table named 'SNR_log', out of which I have queried to obtain below list.table SNR_Log


Next,I designed a split form, with a text box.In this text box SNR is enterted to find and filter from the list. To perform this operation 'Apply filter' macro is used with a where condition,





[SNR] Like "*" & [Forms]![SNR_History]![Text17] & "*"


Problem: Is it possible to filter by inserting SNR in the textbox and obtaining the below result. here UID is filtered


In other words, with SNR as input, display UID and all the SNR under that UID.


Aucun commentaire:

Enregistrer un commentaire