Update Table-A from Table-B

[esskaykay]

I have a database where we track Permits and Inspections. I would like to update the T_Inspect table based on an entry in a form. If I keyin a permit number, I want it to populate the Inspection form with the data from the T_Permits table (not simply display the linked data – I can explain later).

I have attached a small sample of my database. In my example, if you keyin EC-01, I want it to update the Project_Name field in T_Inspect. Any suggestions would be greatly appreciated.

Thanks,
SKK

 

[CyberLynx]

Here is your sample slightly modified.

In a nut shell, what I had done was I changed the Permit Number TextBox on Form into a ComboBox and populated it with Data from the Permits Table. There are four columns of Data within the Combo.

When a Permit number is selected (or entered) we fill the other TextBoxes on Form based off the Column data related to the Permit Number. This is done within the OnClick event of the ComboBox.

Combo Column(0) Holds the Permit Number
Combo Column(1) Holds the Project Name
Combo Column(2) Holds the Project Number and finally,
Comb0 Column(3) Holds the Project Location

.

 

[esskaykay]

This is great. I'll have to incorporate into my full DB but I'm sure this will do it.

Again thank you very much,
SKK