Automatic numbering uses long integer data type (long), while the information input with textbox is character type, which corresponds to the text type in ACCESS database.

If you want to check the ID, you can try.

adodc 1 . record source = " select * from RH where id = " & amp； clng(text 1.text)

Be careful not to use single quotation marks.