Parameter Queries Prompt Twice in Forms

[ConnorGiles]

Its all in the Title guys - but one other thing is that it also prompts twice when i try printing or try to save the current page as a pdf and also when i switch record? i think its a problem with the subform as it always is trying to fetch data. would there be a way to make it so that the subform and the form are linked so that the parameter query prompts once and the information stays there rather then having to prompt again when printing or saving as pdf?

Two more things - on my total value box i wish to be able to always show 2 decimal places

The code already in place is :

Net : =Sum([TotalValue])
VAT: =Sum([TotalValue])*0.2
Gross: =[Text8]+[Text10]

(Net is Text8 and VAT is Text10)

i have already specified that the decimal place value is 2 instead of auto but it still doesnt work - if the number is a whole number i still wish to see .00 at the end of the field.

One last thing - Would their be a way to carry over the information from my delivery note to my invoice note? which would save a lot of time retyping the parameter query.

Thanks.

Connor
:banghead:

 

[ConnorGiles]

Main problem i wish to be sorted now is the Prompting - cant access just print or save what is on the screen currently?

 

[Brianwarnock]

If you use a pop up prompt it will appear every time the parameter is required, better to provide the parameters by an open form

Forms!formname!parametercontrolname

Brian

 

[Brianwarnock]

You should not double post

http://www.access-programmers.co.uk/forums/showthread.php?p=1377985#post1377985

Brian

 

[ConnorGiles]

So there is no way to not make it prompt? and use what is already there?

 

[Brianwarnock]

Not that I know of.

 

[vbaInet]

You should not double post

http://www.access-programmers.co.uk/forums/showthread.php?p=1377985#post1377985

Brian

... also try and keep your thread focussed on one question not unless they are completely related.

Where are the parameters actually set? And how is it set up?

If you saved the value in a variable once and call it from a function/property it will read from the variable. Or like Brian mentioned, pointing it to a textbox who's value will be used as the parameter.