Search results

Hi Ken, Thanks for the help. So, now it has worked. It shows Product Price 3 value as 0 in the message box, as default is zero I assigned the value from the combobox to the Product Price 3. Then it shows me the actual value from table in the message box. So both parts work now. Now as next...

Same Error as in the earlier attachment: cannot find the field '|' refererred in your statement. and the statement is: Forms![Add Promo Details]![Product Price 3] = [Me].[Combo454].Column(1)

Ok that means, I should write the code snippet the following way: forms!Add Promo Details!Product Price 3 = [Me].[Combo454].Column(1) Here: Add Promo Details is the form name Product Price 3 is the field where we want to display the price Combo 454 is the combobox where we are...

Combo454 is the name and Lines 3 is the Control source

When I put the comma as you mentioned, there is no error.

When I put the comma as you mentioned, there is no error.

Ken, Still not getting through... I went into Event Tab, selected .... button, then went into Code builder and in the After Update section. Here is the code piece ---- Private Sub Combo454_AfterUpdate() [me]![Product Price 3] = [me]![myCboBox].Column(1) End Sub ---- Then went back to...

How Should I assign Product Price 3, that is the field in which the price should be displayed? [me]![Product Price 3]=[me]![myCboBox].[column](1) Is that correct?

Ok Let me tell you again, now what I did: Control source: Lines 3 Rowsource: SELECT DISTINCT [CustomerProduct].[productdescription], [CustomerProduct].[product Price] FROM [CustomerProduct] where ([CustomerProduct].[brands]=Text498) and [acc number]=[parent acc number]; bound Column: 1...

Hi Ken, Thanks for the reply. But still somehow, I am getting an error. As In my last post I have given the SQL Statement. Now I get an error as shown in the attachment. I shall appreciete you help and reply... K

Hi Mc, I am having the same problem. Can you help me? regards K

Do you mean in the same rowsource for the product description? e.g: Select Distinct Productname, price, duty, tax from customerproduct where productname=xxxx and customername=ssss I passed the statement as you mentioned in the Afterupdate property. I get an error there that the macro does not...

I store the price with order details...

It is on the same form: Select Customer Select Product Actually at this stage the price should be automatically displayed...But I have to use a combo box with a select statement saying select product price from customerproduct where customername=xxxx and productname=wwww Enter Quantity...

Hi Ken, It is like that, as the prices are not dependent on price rules, but individual with customers... regards K

Thanks for the reply. The CustomerProduct table has the Customer and Product relationship e.g. customernumber Product Price X345 E54 45.34 X345 E55 46.23 X134 E55 49.26 X349 E55 41.13 So...

Hi guys, I need urgent help on a simple question. I hope you will be able to help me. I have a table CustomerMaster which stores customer number and name. (Customermaster) I have another table which stores the product details for customer. (customerProduct) I have another table which shall store...

Hi guys, I need urgent help on a simple question. I hope you will be able to help me. I have a table CustomerMaster which stores customer number and name. (Customermaster) I have another table which stores the product details for customer. (customerProduct) I have another table which shall store...