I wasn't sure if I should post this here or in the code section.
Relevant Info: Using Access2003, connected to: http://www.access-programmers.co.uk/forums/showthread.php?t=174345
What is involved:
3 tables.
1 Form.
Tables
Tableprice:
Item Quantity Current Price(which changes based on additions)
TableAddition:
Item Quantity Added Price of New Quantity
TableOutgoing:
Item Quanity Removed etc. etc. Price at time of use (needs to be taken from tableprice)
Form
FormChanges; includes many fields. Relevant ones are: Text box for amount of product used, list box for the item used, and a locked text box for the current price.
What I need: to keep a record of each outgoing transactions 'current price' which is stored in a seperate table (tableprice) from the table of transaction histories (tableoutgoing).
What I have tried: Multiple attempts in the event expression builder in the object properties of the text box i've created to display the current price (contol source is tableoutgoing. so that the data may automatically be placed into the record that the other information given in the form is going to)
Stuff like:
*In the text boxe's properties under Event...through expression builder.
SELECT fldprice
INTO tableoutgoing
FROM tableprice
WHERE flditem = fromchanges.lstitems
**with and without square brackets have produced errors.
If anyone can give me a helping hand on this it would be appreciated, I've spent most of the morning on this, I have read through many websites but have been unable to find what I am looking for.
Thanks,
ConfusedA
Relevant Info: Using Access2003, connected to: http://www.access-programmers.co.uk/forums/showthread.php?t=174345
What is involved:
3 tables.
1 Form.
Tables
Tableprice:
Item Quantity Current Price(which changes based on additions)
TableAddition:
Item Quantity Added Price of New Quantity
TableOutgoing:
Item Quanity Removed etc. etc. Price at time of use (needs to be taken from tableprice)
Form
FormChanges; includes many fields. Relevant ones are: Text box for amount of product used, list box for the item used, and a locked text box for the current price.
What I need: to keep a record of each outgoing transactions 'current price' which is stored in a seperate table (tableprice) from the table of transaction histories (tableoutgoing).
What I have tried: Multiple attempts in the event expression builder in the object properties of the text box i've created to display the current price (contol source is tableoutgoing. so that the data may automatically be placed into the record that the other information given in the form is going to)
Stuff like:
*In the text boxe's properties under Event...through expression builder.
SELECT fldprice
INTO tableoutgoing
FROM tableprice
WHERE flditem = fromchanges.lstitems
**with and without square brackets have produced errors.
If anyone can give me a helping hand on this it would be appreciated, I've spent most of the morning on this, I have read through many websites but have been unable to find what I am looking for.
Thanks,
ConfusedA