469,646 Members | 1,496 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,646 developers. It's quick & easy.

Accessing single record from multiple item form in VBA

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
2 2812
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
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.

Similar topics

19 posts views Thread by davidgordon | last post: by
7 posts views Thread by =?Utf-8?B?TG9zdEluTUQ=?= | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.