sir

i want to enter Product ID in sub form , then
item name, pirce are coming automatically in sales form, how i can do it pls  help me sir....

---

Reply from Richard Rost:

Any time you say "automatically" you're almost always talking about event programming with either a macro or VBA code. This is WAY beyond my beginner and even expert series. I start covering this in my advanced lessons (Access 301).