Search results

no chart just a form trying to make scense of what it doing Private Sub Form_DataChange(ByVal Reason As Long) Me.Refresh Me.Requery End Sub

Im looking over an database that i have inheriated to reconstruct. i notice on form there is an event DataChange(ByVal Reason As Long) what does this do what is the purpose?

Thank you for your help

it worked can u tell me what i did wrong please

allow you to enter another search and populate the results in the listbox without shutting the form

when u hit clear and enter new department to search nothing happens it suppose to pull all project numbers for that department

then when you hit clear to enter a new search instance nothing happens

double click on the one of the numbers then record pulls up

right now i have work around but it not what i want i put in on clear button, it not what i want to do but it works another is how do i stop user from erasing the first search with backspace button Private Sub cmdClear_Click() cboDept = "" cboTEch = "" txtCapaNo = "" StartDate...

go to cheese line 1 there no projects in admin

i need i think but not sure how to do it once you hit clear it reloads the form.

u open form in area on top select department then go to search button click on it . project numbers populate in search list box double click on the number it pulls data up. hit clear to clear search results now i want to entere another search but it dont work

here my file.

i can send u my file if you like

when i search it blank again only i can search again if i close the form

Good day, i have a form that i use i have search function in that form it works but there one problem it only allows me to search once i have close the form and restart the form

one person 1 day it actually suppose to have one person track swab site testing so each employee test for listeria at locations and those locations are tested daily by the employee each day .

they type it in