How to create a link to another form to edit the records in a SUBFORM?

[snehal0909]

Hi,
Newbie here.

I am trying to create incident mnagement database.
in the main form (datasheet view) of my database i am able to click on a record to open it in form view & edit it & when i close it, it saves the data i entered & shows on the gridview straight away. I was able to do it using vba code & some help from other people.

I have a similar problem this time, he only difference is that i am trying to set up the same for A SUB FORM
See this picture

Here is the database

Please help!

[PianoMan64]

Hi,
Newbie here.

I am trying to create incident mnagement database.
in the main form (datasheet view) of my database i am able to click on a record to open it in form view & edit it & when i close it, it saves the data i entered & shows on the gridview straight away. I was able to do it using vba code & some help from other people.

I have a similar problem this time, he only difference is that i am trying to set up the same for A SUB FORM
See this picture

Here is the database

Please help!

Well, what you're going to need to do is to retrieve the Record ID or Primary Key to that record in the table that you're trying to edit and pass that to a form that is bound to the recordset of the subform.

That would be the way to do it. Without being able to open your database, because it is in an Access 2007 format, and I only have 2003, I am not able to make any changes to your database.

If you can send it as a MDB, then I would be able to work with it.

Hope that helps,

Joe P.