Recent content by Vu_Ho

Thanks alansidman, can this method apply to a query? or it must be a table? 'cause my two control are based on a query.

I Have 2 combo box on a form: Product_Type (6 values) and Product_Name (30 values and each belongs to a type), I want to narrow down the Product_Name to related Product_type whenever I select a type in the first field. Is there anyway to do this? Thanks

Actually I am trying to do something like If Order type = Urgent, then the Orderreturndate=Date()+2.

Oh I got it, my mistake! I put the calculation in the query instead of on the form. Another question is how about the date? I put this this way: Private Sub Order_Type_AfterUpdate() Select Case [Order_Type] Case "Urgent" Me.Total = Round(Me.Quantity * 20 + Quantity * Product_Price)...

Guys, there is still a problem: Actually I have 4 fields: 1. [Order_Type] with 3 types: Regular, Urgent, Very Urgent; 2. [Quantity]; 3. [Product_Price], which is locked (don't want users change this); and 4. [Total] I want whenever the Order_Type = Urgent or Very Urgent, then Total would be...

Thanks very much

This is what I put under the AfterUpdate property of a field named [Order_Type] which has three types: Regular, Urgent and Very Urgent; whereas when it comes to Urgent, then customer would have to pay a fee of $20 and the return date would be Date()+1; like wise with Very Urgent. Private Sub...

My question is this: I have several controls: [Order_Type] with 3 values: Regular, Rush and Extremely Rush, [Unit_Price], [Quantity] and [Total] By default: [Total]=[Unit_Price]*[Quantity] What I want is when [Order_Type]="Rush" then [Total] would be:[Unit_Price]*[Quantity]+20 and if...

I want to put an expression that count all Debt in a field named "Payment". What would be an expression for this: =Count([Order].[Payment], "debt")? Thanks a bunch

Problem is I want this value to be loosen, people can enter the factual values that may not be as calculated. Let me be a little bit more specific: theoretically, what pr2-eugin proposed is right. but in fact, sometimes, people want to enter different amount in the total because customers keep...

This may sound simple but I don't really know how to go about this: I have 3 fields: "Quantity," "UnitPrice" and "Total". I want to put a code that before I enter the field, the default value of "total" would equal Quantity*UnitPrice" Thanks

Problem is I already created a Lookup field that already included the city in the field. That also included the customers' zip code :(

By mistake, I have split a table into two different ones, whereas the Customers' City fell into Customers' State Table (it should be in Customers' Details Table). Please tell me is there any way to correct this mistake (I don't want to retype all the Cities)? Thanks a bunch

Thanks very much Gina!

I have created a database with relationship as showed in the attachment. Please some one have a look and tell me if it is right? Thanks a bunch