I am sorry...I can not upload the database

Adam has no specific price

charlie has a specific price
by scrolling to differrent customer ,the list in the productid field displaying the specific price of charlie
if I open the query it displays the price correctly

opening query for adam,no special price

that is norman has a specific price
the query is okay but the productid field in subform (I use PRODID in my database for productid) displaying wrongly.
I use the query as the rowsource.

the specific price form

hopefully anybody could hel me

Hi Liem,

OK, I think that the first question you had is why your subform doesn't update pricing when you change the customer in the custname field in the order form and/or why, when the form loads, why it doesn't show the pricing information for that customer.

This is how forms load in Access. The subform loads before the form, so if you start with a new record, it will use the default values in the form before you change the customer is selected so you have to have some code or macro in the main form to update the subform as you select a customer.

If starting with an existing record that already has a customer selected and it isn't showing the correct pricing, then that means your subform isn't set to respond to those changes.

Can you show us a screen shot of the subform in design view with the prodid combo box selected with it's property dialog visible showing the rowsource of that combo box so we can see the full content of it. If necessary, highlight the rowsource and press shift+F2 to zoom. If it just points directly to a query, then we will need to see that query in design view as well.

On OrderF, in design view, select the CustID combo box (representing customer name). In the property window, go to the Events tab. Do you have anything listed anywhere there?

If so, which event(s) is/are used? Are they macros or VBA?

Basically, without looking at every single object and property in your database, I'm thinking you may just need to add an event that requeries the subform when you select a customer.

At the moment the event proerty is still empty

Iam sorry I am not good at vba
I know how to change the new price if the price gets higher or lower

Ok, not a problem, it's one line of code :)

In the events properties, click on the "After Update" event. Next to it will be blank but you should see a drop down followed by 3 dots (ellipses). Click the Ellipses and if prompted, choose "Code Builder". When the VBA Editor opens, it will already have some code entered:

VBA Editor BEFORE adding code

Private Sub CustID_AfterUpdate()

End Sub
Copy

Next, between the first line and the "End Sub" line, add the requery line so it will look something like:

VBA Editor AFTER Editing code

Private Sub CustID_AfterUpdate()

     SUBFORMCONTROLNAME.Requery

End Sub
Copy

1) Click on the code blocks above to expand/copy
2) In the last block, replace "SUBFORMCONTROLNAME" with the actual name of the subform control in OrderF which may or may not be the same as the name of the form it holds.

Save you form and code, close it, reopen it and see if it works as you need it to.

Is it just to write REQUERY on afterupdate event or which event
Thanks

Sorry

is it okay,the rowsource of the productname

the control name

If you click on the grey boxes in my previous post, it will show what you need in vba, or, if you'd rather use a macro, choose macro builder instead of code builder.

When the Macro Builder opens, in the drop down next to the "+" choose Requery and press tab
In the Control Name box, type the name of the SubForm control in OrderF and press tab.
Click Save and Close the Macro Builder.
Save your form and close it. Reopen your form and see if it works.

no...I'd rather use vba
is my vba correct

In the following pictures, I will walk you step by step thru the Macro version as it may be a little less confusing:

1) Click the button with the 3 dots

2) Choose Macro Builder

3) In the dropdown, Select or Type "Requery"

4) In the Control Name box, enter the name of your sub form control (Replace "YOURSUBFORMCONTROLNAME" with your control's name)

5) Click Save (sorry, it's marked as "1" here)
6) Click Close (sorry, it's makred as "2" here)
7) Save your "OrderF" form and close it
8) Reopen your "OrderF" form and see if it is working.

Sorry if I went too fast or threw too much at you earlier.

is it right the controlname "PRODUCTNAMECOMBO"

The control name you need is the name of the sub form control itself in the OrderF. See below

oooo....I am sorry

The subform control is the control that is selected with the orange border around it in the image above of Richard's TechHelp Invoicing Template/Order Form. Whatever the actual name of your subform control is, that's what you put in the control name field

oooo....sorry

Oooo...sorry

actually adam has no special price

charlie has one

Sorry,Iwas not careful to read Your explanation....I am very sorry

the custid field (orderf) name is custnamecombo and I have to requery the orderdatailf (subform)