Problem with form/subform.

[Frank Martin]

I have Access2000 with WindowsXP.

I am redesigning an invoice form which consists of a main form based on the
"CustOrders" table, and a subform based on the "InvoiceLines" table.

The "InvoiceLines" subform has some expressions of the sort
"CCur([ProductID].[Column](2))" (i.e. for item prices) and these are there
to place the appropriate values into the invoice lines fields.



All invoice values are supposed to be collected into the "QryINVOICE" for
further processing, but the expression above (

CCur([ProductID].[Column](2))

) refuses to appear in this query as do derived expressions based on this.



Everything else seems to work.



Please help, Frank

 

[John Vinson]

The "InvoiceLines" subform has some expressions of the sort
"CCur([ProductID].[Column](2))" (i.e. for item prices) and these are there
to place the appropriate values into the invoice lines fields.

This would look in the *THIRD* column of the combo box - the Column
property is zero based. Is that what you expect?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Frank Martin]

The "InvoiceLines" subform has some expressions of the sort
"CCur([ProductID].[Column](2))" (i.e. for item prices) and these are there
to place the appropriate values into the invoice lines fields.

This would look in the *THIRD* column of the combo box - the Column
property is zero based. Is that what you expect?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

The correct column value is returned and is displayed in the "InvoiceLines"
subform.
However the problem is that this value does not appear in the QryInvoice.
Other values based on a similar column property do appear. It's all very
strange.

 

[John Vinson]

However the problem is that this value does not appear in the QryInvoice.
Other values based on a similar column property do appear. It's all very
strange.

Please post the SQL view of QryInvoice.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Frank Martin]

Please post the SQL view of QryInvoice.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

Sorry to cause so much trouble, but I have fixed it.
I was using an unbound control for that field when I should have been using
the one from the field list.
It works fine now.