C
chas47
Using VBA I want to open a table. Then move to first record, then check the
data in [name field] and compare it to the data the user has typed into a
text box on a form. When it finds a match or the end of file - use a message
to inform the user of results. The crude code below will give an idea of
what I am trying to do. I have been away from Access and VBA four about
seven years.
Open table/recordset
Move first
Do until EOF
Read [name field]
If [name field] = Me.[text box] then
Message “You’ve hit pay dirtâ€
endsub
EndIf
Move Next
Loop
Message “Search failedâ€
data in [name field] and compare it to the data the user has typed into a
text box on a form. When it finds a match or the end of file - use a message
to inform the user of results. The crude code below will give an idea of
what I am trying to do. I have been away from Access and VBA four about
seven years.
Open table/recordset
Move first
Do until EOF
Read [name field]
If [name field] = Me.[text box] then
Message “You’ve hit pay dirtâ€
endsub
EndIf
Move Next
Loop
Message “Search failedâ€