more access problems |
||
 Tr goremaster 
Having trouble in access, i have the tables: TblSales ------------ SaleID (PK) EmployeeID DateOfSale TimeOfSale StockID Quantity UnitPrice TotalSalePrice and TblStock -------- StockID Description UnitPrice TypeOfStock Damaged? Shelf-Life Edited? CurrentQuantity SuggestedStockLevel QuantityToOrder I have two forms with exactly the same fields FrmSales and FrmStock In the sales form I have a seperate part that looks like this --------------------------------- | StockID | \/ | (combo box) --------------------------------- ----------------------- Quantity | | (text box) ----------------------- ----------------------- Unit Price | | (text box) ----------------------- ----------------------- Total Sale Price | | (text box) ----------------------- the above is from the sales form with the combo getting information from TbLStock, while text boxes all linked to TblSales, what I want to do is this... when a StockID is chosen, i need access to look into TblStock and retreive the Unit Price from there and put it into the Unit Price box in FrmSales It would help if there was either code to do that, or a better way that I can't think of. ------------------------------------------------- The Gore Master - Mere Trooper I'm as good a Trooper as Rincewind is a Wizard. ------------------------------------------------- Replies:
|
||
| CyberArmy::Forum v0.6 Generated In 0.02974 seconds |
2002-12-13 17:02:09
2002-12-13 16:36:10
2002-12-16 01:10:39