Searching for elusive records..

[thetambarineman]

Hi all,

having another problem with my application - the thing is that i have 2 forms- frmfeedback and frmemployer - i've already passed details from the frmemployer form to the frmfeedback form.. but now i have details that i want off another form-as yet uncreated - the thing is that i want a search procedure to read 1 itm off the frmfeedback form- search it against the unexistant form..

does Ne1 have an idea??

Thanks in advance..

Paul..

 

[JeremyM]

Paul,

I did that earlier. What I did (which may not be the most effeciant) is set up a
recordset of the variable I want to find. Then run your SQL through a loop with and index such as i. ANd of course, i= i +1 .

OR
if your looking for literally matching say:

use SQL statement.
select field1, field2, from uncreated where
frmfeedback. employedID = uncreated.employedID

Assuming you also are using SQL. It will search all records in the uncreated table to find the match.

Jeremy
Hope this helps.