Accessing single record from multiple item form in VBA

[jamieda]

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.

[Kevin Wilcox]

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.

[jamieda]

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.