Recordset search for ID then obtain column information about that row

[Ruegen]

I'm doing a recordset in vba and I'd like to seek a specific ID then return into some variables the column values of that particular row



so I look for the ID

then I get the rs!name and stuff that into a dim

rs!name

I've found rs.findfirst = "ID=" & lngNumber

works however I don't know how to get the other fields once found

[pbaldy]

Rather than open the recordset on the entire table, I'd open it on an SQL statement that only returned the desired row:

"SELECT * FROM TableName WHERE ID=" & lngNumber

[June7]

What do you mean by 'get the other fields'? Don't you know the field names?

Like this https://www.accessforums.net/program...orm-45725.html

[Ruegen]

What do you mean by 'get the other fields'? Don't you know the field names?

Like this https://www.accessforums.net/program...orm-45725.html

Say it is row 125 (or ID 125)

then I want 125's rs!FirstName, rs!Surname, rs!address

etc

so say it finds row 5 and then I can obtain all the data from those fields

[Ruegen]

Rather than open the recordset on the entire table, I'd open it on an SQL statement that only returned the desired row:

"SELECT * FROM TableName WHERE ID=" & lngNumber

Yeah I thought about that - I might do that anyway.

[Ruegen]

Nevermind - I see what I am doing wrong in my code.

Putting in the wrong variables....