By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,060 Members | 1,906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,060 IT Pros & Developers. It's quick & easy.

Accessing single record from multiple item form in VBA

P: 2
I have a multiple items form displaying the contents of a table. It has a primary key and the records are ordered by this. I want to be able to manually select a record in the form and then reference that record using VBA. However, I do not know how to create a recordset with that single record. I am using Access 2007.

Thanks in advance.
Nov 12 '07 #1
Share this Question
Share on Google+
2 Replies


P: 68
This might be my stupid day, but I'm not clear what you mean here! What do you want to happen once you've selected your record?


I have a multiple items form displaying the contents of a table. It has a primary key and the records are ordered by this. I want to be able to manually select a record in the form and then reference that record using VBA. However, I do not know how to create a recordset with that single record. I am using Access 2007.

Thanks in advance.
Nov 12 '07 #2

P: 2
I want to be be able to select the entire record manually on the multiple items form and then process it in VBA. The muliple items form is called from another form and the action of selecting a record will be used to populate fields, with some modification, on the original form. I want to do that part using VBA but do not know how to create the recordset from the selected record (which I assume will only have one record) in the first instance.

Thanks for your help.
Nov 12 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.