Using Find in Access

[Guest]

I have a form that pulls up a name then searches it in a table:

st1 = Left(Me.Combo2.Value, 7)
DoCmd.OpenTable "Org2"
DoCmd.FindRecord st1, acAnywhere, False, acSearchAll, False, acAll, True

How do I determine a field in the same record's value?
For example, it opens a table, searches the whole table for a user name,
selects it. I actually don;t even want this visible. I want to know the value
in City field when it finds the username in a record. And I want to do it
multiple times.

So do I need some kinf of found property?

If found = true then...

For example, a combo lists usernames. I choose one. Tell it to look in a table,
then I want to populate a listbox with all the Cities, Addresses, whatever, in
that form where the username came up in a record on the table. How do I do
this?"

It seems different than a Word or Excel find.

(e-mail address removed)

 

[Tom Ellison]

Dear Spam:

Instead of searching the table, use a query to return only those rows
you want. This is what queries do very easily, and is not so easy the
way you're trying, nor is this very fast.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts