Search results

'0 Sale' is just a product in the product table and i slotted it inot the default properties of the combo box for the product name on the form therefore on load, in the product name field '0 sale' is there and therefore prodID '1' should appear which then gives a default price of £0.00 as below...

Yep, frmsales is the form with the boxes on - i removed the third parameter and it did still work but even though I have the default as "0 Sale" for the prods field, it is like it needs to refresh the prods field as when I drop down and then select "0 Sale", it populates the prodid field

Hey Nick, The form is setout as: ProdID Productname (Combo) ProductPrice as below: ProductID - =DLookUp("[productid]","qryproddetails","[productid] =" & [Forms]![frmsales]![Prods]) ProductName is bound to Productname in tblproducts ProductPrice is...

Hi, I have an access form with: ProductID Product name Product Price When i select the product name from the combo, the productid and price populate as they should but on loading the form, i cannot get the default in the product ID and product price fields to default to blank / 0 - they disply...

Hi all, new to the forum but not bad with databases. Please see attached - have added code to open form for mail merge but would love to be able to use the method attached to select from drop downs both letter type but mainly client details to populate Had slight issues with form fields also...