I have few problems about a List Box in a form. There is a Form1 in my DB that is a search form with a list box. Attached is my DB. my problems that I need help are:
1). The "Clear" button for some reason, it's only clear the Text box but not the List Box which I need to clear the data too when click on it.
2). when I search "tes", it show everything that has "tes", I want to be able to click on each record in the ListBox the open the form that associate with the Class and TagNo (for example: if the record the Class is "Computer" then open "Computer Form with the same TagNo so it opens the correct record with the correct form, if the "Class" is Property then opens "Property Form" with the TagNo associate with the form. I was able to open the form but not with the correct TagNo and correct form.
3). Is possible that when the records show on the ListBox, whatever the IPNo is assigned to a user, the IP address will be shows Red, if the IP address is unassigned then is Black in the ListBox?
4). Whenever Form1 first Opens, the ListBox should be blank. (if there is noting in the Text box, Form1 ListBox should be blank)