Link pop up form data with main form data

[NDClark]

I have a main form with a block of data that cannot be edited. This is what
I want to happen. I have the block of data when Dbl clicked it will open a
smaller pop up form with the data block in it. This can be edited.

The problem is even if I change my record on the main form and Dbl click the
data block the smaller pop up opens only to the first record. I want to be
able to open the smaller pop up to edit the data I am currently on.

Thanks for any help.

 

[Jeanette Cunningham]

Have a way to uniquely identify the block of data you want.
Very often this is the primary key of the containing the block of data.
It can be a different field, as long as it has unique values.

To open the popup form use this type of thing

DoCmd.OpenForm "[NameOfPopup]", , , "[PKey] = " & Me.PKeyID, , acDialog

If the primary key is a text field use quotes like this

DoCmd.OpenForm "[NameOfPopup]", , , "[PKey] = """ & Me.PKeyID & """"

Copy and paste this into notepad to see the quotes clearly.

Note: replace [NameOfPopup] with your form's name.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

I see a single word was missing in that last post.

This: Very often this is the primary key of the ............containing the
block of data.

To this: Very often this is the primary key of the *record* containing the
block of data.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Have a way to uniquely identify the block of data you want.
Very often this is the primary key of the containing the block of data.
It can be a different field, as long as it has unique values.

To open the popup form use this type of thing

DoCmd.OpenForm "[NameOfPopup]", , , "[PKey] = " & Me.PKeyID, , acDialog

If the primary key is a text field use quotes like this

DoCmd.OpenForm "[NameOfPopup]", , , "[PKey] = """ & Me.PKeyID & """"

Copy and paste this into notepad to see the quotes clearly.

Note: replace [NameOfPopup] with your form's name.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

I have a main form with a block of data that cannot be edited. This is
what
I want to happen. I have the block of data when Dbl clicked it will open
a
smaller pop up form with the data block in it. This can be edited.

The problem is even if I change my record on the main form and Dbl click
the
data block the smaller pop up opens only to the first record. I want to
be
able to open the smaller pop up to edit the data I am currently on.

Thanks for any help.

 

[NDClark]

Thanks Jeanette!

I see a single word was missing in that last post.

This: Very often this is the primary key of the ............containing the
block of data.

To this: Very often this is the primary key of the *record* containing the
block of data.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Have a way to uniquely identify the block of data you want.
Very often this is the primary key of the containing the block of data.
It can be a different field, as long as it has unique values.

To open the popup form use this type of thing

DoCmd.OpenForm "[NameOfPopup]", , , "[PKey] = " & Me.PKeyID, , acDialog

If the primary key is a text field use quotes like this

DoCmd.OpenForm "[NameOfPopup]", , , "[PKey] = """ & Me.PKeyID & """"

Copy and paste this into notepad to see the quotes clearly.

Note: replace [NameOfPopup] with your form's name.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

I have a main form with a block of data that cannot be edited. This is
what
I want to happen. I have the block of data when Dbl clicked it will open
a
smaller pop up form with the data block in it. This can be edited.

The problem is even if I change my record on the main form and Dbl click
the
data block the smaller pop up opens only to the first record. I want to
be
able to open the smaller pop up to edit the data I am currently on.

Thanks for any help.

.