Display single record or duplicate records

[mcervenka1]

MS Access 2010. I am using a split form and when I perform a search for a record, and there are no duplicates, need to display that single record and not the other records in the table. If are two or more records (duplicates), need to display only those duplicates and not other records in the table.

[mcervenka1]

So if I remove the search button, what should the VBA read after "Private Sub"? Should I delete "txtSearch_AfterUpdate()". If so, what should I replace with in order to complete the Private Sub or does the Private sub start above "On Error GoTo EH"

[twinnyfo]

Rename your Text Box to txtSearch. That is a start.

[mcervenka1]

For Text box where Receipt Number or ANumber or Serial Number is entered:
Name - Text438
Caption - empty
On Click - empty no event procedures

YOu want me to change Name from - Text438 to txtSearch?

[twinnyfo]

Yes. OR you can change the name of the procedure. It doesn't matter. But that is how the procedure knows which control it is connected to.

[mcervenka1]

Ok.. I have changed the name of the unbound textbox to txtsearch. Enter receipt number and still just sits there. You said earlier that I did not need the SEARCH command button. Should I still remove the button? What about the VBA code?

[mcervenka1]

please see attachment when I debug.

[twinnyfo]

check to make sure that the After Update Event in the Text Box has [Event Procedure] in it. If not, click the drop down of that field and select Event Procedure.

[mcervenka1]

ok... Event Procedure is there now. Still no search performed. Earlier was told do not really need search button. I am using the search button with no results. Should I delete search button, if so, what about the related VBA coding

[mcervenka1]

Hello. The link I have provided is to the site where I originally got the guidance for my Update Record search by list box. I do not know if it is helpful in my situation, since so much has changed with VBA. https://www.youtube.com/watch?v=wCPs4aE5I2w

Thank You

[twinnyfo]

Before we continue with this, do you understand the nature of procedures and controls? A control is linked to a procedure based upon the name of the control and the name of the procedure, as well as the event that fires the procedure. When you have a control and go to its properties, and select “Event Procedure” from the drop down, it will automatically take you to the VBA module that should hold that procedure. In your case, it should take you to the procedure you have created. If not, it should create a new event procedure.

For example, take your text box txtSearch. In the properties, find the After Update event. Go to the drop down and select [Event Procedure]. It should take you to the VBA procedure we have written called txtSearch_AfterUpdate.

Let me know what happens.