Parameters & Requery 1

[OB1too]

I have a Form(FormX) which is based on a Query, which in turn gets parameter data from another Form(FormY) a la -
Format([Forms]![FormX]![Dinput],"0000000000&quot

If I have an Command Button, on FormY, that actions Requery, I get the parameter box with the description -
[Forms]![FormX]![Dinput]
which is fair enough however -
question is - is there a way that the Description on the Parameter box can be set so that it shows for example -
"Enter Supplier No" ?

Thanks

 

[sko]

As far as I know, a parameter query can get it's values by prompting the user or by pointing to values in a form as you have done. If the form isn't open, you will get the prompt you are seeing. If you want a user prompt you will have to change the criteria section. Replace your reference to the form with text in square brackets.

[Enter Supplier No.]

Is FormY being used only to gather values for FormX query?
If so, it looks like you've got most of the pieces but need to do a slight modification.

 

[OB1too]

Thanks SKO....on rereading my post, got the form names a tad mixed up so my apologies if that was confusing.
For
Form(FormX) READ Form(FormY)
Form(FormY) READ Form(FormX)

and for
Command Button, on FormY
Read
Command Button, on FormX

All that aside, I decided to take a different approach, with the initial form set up in a Menu structure with push button commands and no parameters.
The command buttons are linked to macros which open other forms with input fields which when submitted open the related Data Form created by an underlying query.
This way I can have a push button command on the Data form which reopens the same form with the input fields on it.
Hope that all makes sense this time.
Thanks again