Q. How do I code a button on subform to open pop up to proper record?

[Jim Jones]

Hi,

I have a nested subform, on which I have a buttonwhich opens a pop up
form.

That pop up is related to the calling form via the ServiceTicket
field.

I want the pop up to open to the correct record, but I can't figure
out the syntax, (ex. Me. ? ), to place ont he button's click event.

Can someone help?

Thanks,
jim

 

[Roger Carlson]

On my website is a small sample database called "Subform3Levels", which
illustrates how to do this (if I understand your question correctly).

 

[Jim Jones]

Hi,

I have a nested subform, on which I have a buttonwhich opens a pop up
form.

That pop up is related to the calling form via the ServiceTicket
field.

I want the pop up to open to the correct record, but I can't figure
out the syntax, (ex. Me. ? ), to place ont he button's click event.

Can someone help?

Thanks,
jim

I need to clarify something with my problem.
If I enter the ServiceTicket number, and save the record, close the db
and open it, it will open to that record, when I have the proper
record displayed.

But, i'd like it to copy the ServiceTicket number onto the proper
field of the pop up form.

But, since the button is on a subform of a subform, I imagine the
syntax would change. I just don't know how.

Thanks in advance,
Jim

 

[Roger Carlson]

In that case, I have another sample called "SubformReference" which
illustrates a number of issues with referencing controls on subforms and
subsubforms.

 

[Jim Jones]

In that case, I have another sample called "SubformReference" which
illustrates a number of issues with referencing controls on subforms and
subsubforms.

Roger,

I still have a problem:

(By the way, I appreciate your repsonse and the link to your wealth of
information.)

I downloaded the subform databases, but I still need something, for
which I didn't see an example.

I have a subform within a subform, but I have a button on that nested
subform, which opens a pop-up form. That pop up form should have it's
ServiceTicket field updated to reflect the value of the nested
subform, right when the pop-up form opens.

I tried your databases, and they do answer part of my problem, but not
all, and wonder if you could include an example, as what I need at
this time, within your extensive library.

Thanks,
Jim