Select current record from list on form

[threadgills]

I have a form that lists open work orders that is based on my main table. I want to be able to click on a particular work order and give the details from another table, mainly the sum of the revenue.
The textbox on my form (frm_Main1) is named WRNumber. Here is my statement:

Set rs = CurrentDb.OpenRecordset("SELECT WONumber, Sum(REVENUE) AS SumOfREVENUE FROM tbl_Details2 where tbl_details2.wonumber = form_frm_Main1.WRnumber group by wonumber&quot

I get a "Too few parameters. Expected 1" error.

What am I missing?

Thanks!

 

[jebry]

Hi!

This is proper syntax:

Set rs = CurrentDb.OpenRecordset("SELECT WONumber, Sum(REVENUE) AS SumOfREVENUE FROM tbl_Details2 where tbl_details2.wonumber = " & Forms!frm_Main1!WRnumber & " Group By wonumber&quot

hth


Jeff Bridgham
bridgham@purdue.edu

 

[threadgills]

You're a life saver!!!!!!!! It's amazing that if you don't have it as text, it ain't gonna work!

Thanks!

 

[jebry]

Wow! I've never saved someone's life before! Can't wait to tell my wife!



Jeff Bridgham
bridgham@purdue.edu