Find Record Button

[edbloom]

I need help in getting the following pseudo code working.
Thanks in advance.

procedure btnFind_Click()

Ask for Last_Name & First_Name
Search recordset (table)
If Record Count > 1
list all records in popup box
allow double-click selection of right person
populate form (not bound to table)
ElseIf Record Count = 1
populate form (not bound to table)
Else
display MsgBox "No Records Found"
End-if

End procedure

Form is not bound to recordset (table) as Event btnUpdate_Click() will do this.

 

[ssatech]

Did you not post this already?

thread702-1220995

 

[edbloom]

Yes, I did. It was in a different forum. The solution I got worked but is awkward to use. I was hoping to get another view point in the actual VBA forum.