Mr. Rost,

I can create tables, forms, queries, reports and I also understand the relationships.

But My problem is working on retrieving information from tables/queries to be automatically entered in a form. Creating Job Quotes for example, how do to show the datafields in the form by clicking one field for example a TDJob number. Also using multiple tables.

What would you suggest I should get?
302? 301?

Another one I am doing is to track the number of hours that a CAD operator uses his/her time for a particular Project of Job.

---

Reply from Richard Rost:

Ben, I believe you are looking to learn event programming. Specifically, if you want to select a value (say a job number) and have the rest of the information about that job automatically populate in the form, you need an AfterUpdate event. It's not that hard. I have a video in the tips section that shows how to do it... and I cover this in my Access 303 class. So, yes, to answer your question, you should probably start at Access 301. That's where I start to cover advanced topics like VBA.