Problem with form/subform.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

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
 
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.
Click to expand...

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
 
John Vinson said:
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.
Click to expand...

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
Click to expand...


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 said:
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
Click to expand...


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.
 
Back
Top