What do you mean you can’t do it? Are you getting an error message? What is it you’re trying to do?

Please be more specific. See Rule #2.

Hi Liem, please keep in mind that we are not all seeing what you have in your database so it is difficult to assist you. Is your database set up similar to Richard's Access Invoicing Template? If so, you might add a product "Custom Trademark" or something with a price that you could add from the order form.

Richard has videos for Customer Discount and Customer Pricing that show you how to add specific features for specific customers.

Anything else you need help with, you should provide screen shots so we can see what you have and let us know what you're trying to make it do.

Iam very sorry.. I thought I did the customer pricing correctly,as I open the form and opening the query it displayed correct pricing but as I wanted to use it in the subform puzzling me.
I hope you can help me

I want to send the file

could you help me to convert my ms acces file so I can upload it
thanks

If you need to send your database to somebody to help you out, please post this in the Access Developer Network. There’s always people willing to help you out there.

Help me convert the database to png so that I can upload
Thank you

You can't convert a database file to an image. You can, however, take screenshots of the objects within your database.

Snip & Sketch

Help me convert the database to png so that I can upload
I can not upload my ms access database
Thank you

Ooo...Screenshort

adam has no special price ,charlie has this...in form adam is displayed the same price as charlie
hopefully you can help me
thank you

the query correctly displays charlie's specific price

Check the Link Master / Link Child Fields in your Subform object.

Link Master Fields

I used the query as the rowsource of productid field in this form

I only took the prodid+productname+currentprice via propertysheet

Mr ALEX,I am sorry I could not send the database in the forum as well