displaying Autonumber the form

[sandeepdhole]

hi friends........ .
friends in my database ID field is autonumber , i have to display this autonumber in to the form when page loading........ ...........

any one plz help me............. ...
its very urgent.........
thanks......... ..

[kenobewan]

hi friends........ .
friends in my database ID field is autonumber , i have to display this autonumber in to the form when page loading........ ...........

any one plz help me............. ...
its very urgent.........
thanks......... ..

You mean write an sql query to return the id where the value of a second field is given?