var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: What's Wrong with this code? - Parameter Prompt
I've the following code inside a query called "Bobs"
But it kicks up a "Enter Parameter Value" for "Bobs.Receipt" but if I just put [Receipt] it tells me it can refer to more than one table listed in the FROM clause.
JOB: IIf (Jobmain.receipt = Bobs.receipt, Jobmain.job,"Job entry not given")
What table does the receipt field in the Bobs query come from? You can't fully qualify the field based on the query name, it has to be a table name.
[Receipt] from Bobs comes from a Table called AllRecHead. Changing the code to this
gives a parameter prompt on JobMain.Receipt though. Jobmain is another query but one I HAVE to have to give me the result (Jobmain.Job).
JOB: IIf(Jobmain.Receipt=AllRecHead.Receipt,Jobmain.Job,"Job entry not given")
Does that mean I can't refer to another query like this?
As long as you have Jobmain in the FROM clause, it should be fine I think.