For for Joined Query

[Guest]

I was able to create a report that opens a form for parameters and get the
desired results.

So what I'm having trouble doing is using the same form to open a form to
edit the data.

If you enter the standard [Forms]![frmName]![fieldname] for the criteria and
open the form it prompt you with [Forms]![frmName]![fieldname] you enter the
criteria and click OK and then it opens the form.

If you leave the original prompt blank and click OK and fill in the criteria
on the form the query returns nothing.

Any ideas?

Thanks, alot for you time!
Glenn

 

[Jeff Boyce]

Glenn

Assuming your criterion is literally [Forms]![frmName]![fieldname], and that
this is NOT the name you chose for your form and field, Access isn't finding
a form or field named the way you defined as a criterion.

Or was your post not-literal...?

Regards

Jeff Boyce
<MS Office/Access MVP>

 

[Guest]

Hi Glenn,

How are you prompting the user to open the "Edit" form? Are you using a
command button? I would check to make sure you are using the correct event
(something like click button) to open the form. If you are some what
familiar with VBA using a message box is always a good way to de-bug this
type of issue. If this does not help please provide some more detail (how
are you trying to open the edit form, what object you are using to carry this
out, and what event triggers the open).

regards,
Robert