Where did i go wrong

[Bob Vance]

Ok I copied a report "rptOwnerPaymentMethord" re-named it to
"rptOwnerPaymentMethordCI"
On my Form I copied my combobox and renamed it from cbOwnerName to
cbOwnerNameCI, and copied the query and changed its name to
qPayableTotalForPaymentC1
This only differs from my original query where as [2ndCompany] is true and
false in the original query
You might see what I am doing now 2 different Company Print outs subjuct to
[2ndCompany] true or false and they only show in there proper drop down list
Then the text box (tbOwnerID) on my form I changed its row source from
=Val([Forms]![frmBillStatement]![cbOwnerName]) to
=Val([Forms]![frmBillStatement]![cbOwnerNameCI])
But my [tbOwnerID] text box is showing error and will not pick up the
OwnerID (Number)
Where should I start looking? I am sure it must be something to do with this
query but in datasheet veiw it looks perfect

I suspect the problem is when I open my form it is opened as
"OwnerStatement" and it is reconizing cbOwner and not cbOwnerCI when it
comes to open the report!
Private Sub cmdOwnerStatement_Click()

DoCmd.OpenForm "frmBillStatement", acNormal, , , , acDialog,
"OwnerStatement"


End Sub

 

[Bob Vance]

I went wrong because I had the wrong queries all good now