RSGoToRecord in recordsets - Access Developers


	Back to Access Developers Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

RSGoToRecord in recordsets

Despina Karayanni

5 years ago

Hello Richard, As I am new in using recordsets the ACCESS SQL, which has made my database much faster, I confront a problem due to ignorance. It's fine with the commands rs.movefirst, rs.moveprevious, etc. However if I want to specify to go to a specific record, i.e., SELECT * FROM "CUSTOMERT" where customerID = "customerID". How could I specify afterwards to go to a specific record?
Thank you very much for your very useful instructions.

	Adam Schwanz @Reply 5 years ago
If you have a unique identifier like a primary key, you can do rs.movefirst and then rs.findfirst to go to a specific record

	Despina Karayanni OP @Reply 5 years ago
Thank you for your prompt reply. What I need is when I am in form customerlistF to press a command and direct to the specific customer file of the customerF form, which is a recordset. And as such, the customerID field in the recordset is unbound. So, the customerID is not defined.

	Richard Rost @Reply 5 years ago
So your customer form is unbound and you want to dynamically load the fields in the form based on a recordset value? Just pass the ID to the form and open the recordset to just that ID. Or am I not understanding your question...?

	Despina Karayanni OP @Reply 5 years ago
Hello, Thank you for your answer. Yes, this is my problem. I'm trying to do so, using a combobox, unsuccessfully. Where could I find a proper code?

	Richard Rost @Reply 5 years ago
When you create your recordset to load the values, just use the combo box as your criteria `openrecordset("SELECT * FROM CustomerT WHERE CustomerID=" & ComboValue)` Then proceed to load the rest of the values.

	Despina Karayanni OP @Reply 5 years ago
Thank you very much. I was confused with all that complicated SQL code that I tried to apply. It was so simple, actually.

	Richard Rost @Reply 5 years ago
It usually is after you get the hang of it. Just keep learning. I've been doing this for almost 30 years. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developers.

Next Unseen

New Feature: Comment Live View