found a value in a specific field of Table

[Solaris]

Dear Experts.

I am new in Access VBA.
I want to find a value in a Filed(for example : stdName) of a Table (for example stdtbl) by VBA code in Access2010.

Need to sample code for do this.

any available?

 

[Uncle Gizmo]

Dear Experts.

I am new in Access VBA.
I want to find a value in a Filed(for example : stdName) of a Table (for example stdtbl) by VBA code in Access2010.

Need to sample code for do this.

any available?

Do you want to use a query?

If so what is the criteria?

 

[John Big Booty]

Perhaps the DLookup() function is what you are looking for?

 

[Solaris]

Thanx john big booty . it's work