how do I link a pop-up form to a sub-form

[Guest]

I'm trying to use a pop-up form to input specific comments to a record in a
continuous form sub-form but access keep on giving me #Name? error. The
pop-up is activated by a button in the sub-form record, and I'm trying to
read the fields in the record automatically when the pop-up form display so I
don't have to type in the information again , and so the comment will be
linked to the record where I clicked the button only.

Any ideas? I could use some coding if anyone has any idea on that as well.

Many thanks for the assistance.

 

[John Vinson]

I'm trying to use a pop-up form to input specific comments to a record in a
continuous form sub-form but access keep on giving me #Name? error. The
pop-up is activated by a button in the sub-form record, and I'm trying to
read the fields in the record automatically when the pop-up form display so I
don't have to type in the information again , and so the comment will be
linked to the record where I clicked the button only.

Any ideas? I could use some coding if anyone has any idea on that as well.

Many thanks for the assistance.

Care to post some information - e.g. the Recordsource of the popup
form, and the code you're using to open it?

One or other of these is evidently incorrect, but without seeing them
it's more than a bit difficult to tell what's wrong.

John W. Vinson[MVP]

 

[Guest]

Care to post some information - e.g. the Recordsource of the popup
form, and the code you're using to open it?

One or other of these is evidently incorrect, but without seeing them
it's more than a bit difficult to tell what's wrong.

John W. Vinson[MVP]

John,

Many thanks for the assistance but after exercising my brains a bit I found
out what the problem was.

Instead of using query criteria and default value on the pop-up form as:

Forms![Main Form]![Sub-Form]![Field] I was using Forms![Sub-Form]![Field]
only, and therefore the reason why it could not be transferred or filtered
into the pop-up form.

My first experience within the Dicussion Group and quite glad to see how
fast it is to get help from others.

Many thanks,

LRMMarques