Recent content by erbarmen

When I try to Create a Chart based on A Query, which is based on two different tables, I get the following message: You must add field CategoryID to your record source if you want to use this link. What is this and how do I solve it? Thank you. :D

Maybe if I only set Macro2 in The AfterUpdate event of the combo box. The I could set another event in the UnitPrice control. But, what type of event?

mmm... I'd like both the UnitPrice and the LineTotal to update when I change the Product ID. Should I used other types of events (e-g- BeforeUpdate, etc...). I'm really new to this, so I don't know much.

No, that's not the problem. I have three fields (column one is ProductName). Thanks for the tip, though. I'm new to access.

Macro Group Great. So I found out how to create a Macro group. I have the following two Macros: Macro1 SetValue Item: [LineTotal] Expression: CCur([UnitPrice2]*[Quantity]*(1-[Discount])*(1+[SalesTax])) Macro2 SetValue Item: [UnitPrice2] Expression:=[Product ID].[column](2) Then I have the...

Hello. Can I set more than one Macro in the AfterUpdate sector of a Control, in a Form? Thanks

I attached my file on the previous post. Could someone tell me why I'm so messy? And why the UnitPrice = [Product ID].column(2) thing doesn't work? I spent hours on this, and I can't figure it out. :(

One more doubt... I succesfully did what I wanted.:) Now, how can I make the Control "UnitPrice"containing the value =[Product ID].column(2) record this value in the corresponding Table (instead of just showing the value on the form)?:confused:

Thank you Thanks a lot. I think all this answers my questions. :)

Awesome guys. So I have a Table 1 Product ID as primary key UnitPrice and Table 2 Order ID Product ID I wanna create a Form with the Order ID field, where I enter the Product ID and the UnitPrice appears automatically. Do I have to create a Query based on Table 1? And then, what should I...

Hi there. I'm new to Access and to this forum. :D So here's my problem. I want to create an order Entry form, where once I select the Product ID on the Product ID field, the UnitPrice field would look for the product's price in a table and fill in the blank automatically. What is the best...