Relating One Table to Another for Forms?

[Hey Lucy]

Real Estate Database

Two tables -- tblAll Properties and tblPUC (Properties Under Contract), subsequent two forms -- frmAllProperties and frmPUC.


If a property has been placed under contract, then a user should open the frmPUC and be able to select the correct property from the drop down of PropID field. However, no matter what I try, the user CAN select the correct PropID, but the subsequent data fields on the PUC form stay the same as the previous data from a different PropID.

I have used the Lookup Wizard in Tables, and also tried doing it as a combo box on the form. Both fail for me. What am I missing?

 

[mikejaytlabustro]

On the drop down of PropID properties > After Update Event > Macro Builder > Select Requery

 

[Hey Lucy]

Thanks for your response mikejay. Unfortunately, this did not work. ?? Should work but doesn't....data relating to PUC stays the same no matter which property is selected. Putting thinking cap back on....any other suggestions?

 

[Hey Lucy]

I finally accomplished the task with a bit of a work-around...queried the tables for the info, then created form based on query. Works great!