Get Selected Record

[Mike.Eller]

Hi All,
It's a few years since I have played with Access. I know that I have done something similar in the past..but its not coming back to me.

I have a form with a subform. The subform contains a datasheet view of a table. I would like to do one of two things: either double click on a record in the subform table and have it open a new form where I can edit the record OR use a button on the form to perform the same operation.

So, if I clicked the "Edit" button on the form, it would take the currently selected record from the subform and populate the "Edit Form".

How can I do this?

Regards,
Mike

 

[Mike.Eller]

OK...How about this.
How can I capture a click event on a record within the datasheet on the subform?
I can push the data to the "Edit Form" but it only takes the first record...if I select a different record, the first record is still the one that gets pushed to the "Edit Form". So I need to be able to capture the record the user selects.

Any ideas?

Regards,
Mike

 

[lcook1974]

What about changing the view to a continuous form look? (showing all records) you should be able to "scrounch" the view so it looks similar to the datasheet view.

then put a button out to the side ("edit") or on the double click event to open the edit form.

DoCmd.OpenForm "frmNameHere", acNormal, , "[IdField] = " & Me.Id