Here is my progress

The main table has all the information the other tables have. However, I was starting to change the tables and build relationships so that the tables would feed information into each other. There are some hiccups there needless to say. I'm working on that.

The report generates all the data I want. It's in great shape right now.

The form, however, is the big pain.
First,...

I'm super new, treat me like so. (In advance, thank you)

I'm creating a database for our bus information. So the form will have things like Bus #, VIN, Status (active/inactive), tire size, etc.

I want to create a form that generates with assigned blank boxes and then populates information when you enter a bus # based on the bus you chose. From there I would like to know how to lock of unlock the boxes for editing so...