Hi,
I am creating an data entry form with multiple tables and I want to have the forms to be initially blank and use the combobox to pick data from different related tables. The third field text box that should search the tables is that building is in the table if not it should create the table and then the user clicks on a next button to open up a new form that all the building data is entered. Also in this for I want to have some date field only appear if the building inspected field is yes. The inspection fields are from another table and only needs to be populated if building has been inspected.
How can I achieve this? is there any of you tutorials that explains this? I am a programmer so VB is not a problem.

---

Reply from Richard Rost:

Hi Joseph. I'm sure we can help you to do what you want, but I don't understand exactly what you need. Can you take a step back and explain exactly what your database is for, and give me a little more detail about what you're trying to do?