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

[snehal0909]

Hi,

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 & help of a nice guy.

I have a similar problem this time, the 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!

 

[RuralGuy]

If the SubForm had been edited directly as a SubForm then Access would have filled in the ForeignKey for you. Since you are opening another form to do the Add, you need to pass the ForeignKey to the next form. See attached.

 

[snehal0909]

Thank you, you should start a forum of your own!
I posted 5 threads & the 1st got answered very well (by you)
and this one got answered by you.
The 3 threads wasted my 4 days with no reply from anybody.

After posting this thread, i started to think "where is the Rural guy?"

Thanks mate!

 

[boblarson]

The 3 threads wasted my 4 days with no reply from anybody.

Actually, sometimes you just gotta be patient as a lot of it depends on who shows up on the board when, as we're all volunteers here.

But, RG is an integral part of AWF and it wouldn't be the same without him.

 

[snehal0909]

Thanks mate, I think you're right.
I just wanted the db to finish easter weekend.
That's probably why i was impatient.

Oh well, at least my db is ready to populate.
Will add the queries & reports later
(i can add more reports & queries after my database is populated right?)

 

[boblarson]

(i can add more reports & queries after my database is populated right?)

Oh yes... no problem there.

 

[ajetrumpet]

After posting this thread, i started to think "where is the Rural guy?"

I think that sometimes, but then I think:

"Wait, I know the answer to this. I don't need him."

 

[RuralGuy]

Just glad I could help. Have a great Easter weekend.

 

[ajetrumpet]

Just glad I could help. Have a great Easter weekend.

You know I'm kidding Allan.

 

[RuralGuy]

NP Adam. Have a nice weekend.