Here is what I would like to do.
I have two tables. tblGarageUnits and tblGarageUnitInfo
PK for GarageUnit is A1, A2,... and this is the only field in the table (GarageID). GarageUnitInfo has PK which is autonumber, and FK which is same as GarageUnit, and has other fields in the table.
What I would like to do is from my switchboard go to a form that has a combobox only that contians the info from GarageUnit (The unit number only)
and in the after update event open a form that contains info from GarageUnitInfo based on the the unit number selected from the combo box.
Any ideas on the code to do this would be greatly appreciated.
Thanks.
I have two tables. tblGarageUnits and tblGarageUnitInfo
PK for GarageUnit is A1, A2,... and this is the only field in the table (GarageID). GarageUnitInfo has PK which is autonumber, and FK which is same as GarageUnit, and has other fields in the table.
What I would like to do is from my switchboard go to a form that has a combobox only that contians the info from GarageUnit (The unit number only)
and in the after update event open a form that contains info from GarageUnitInfo based on the the unit number selected from the combo box.
Any ideas on the code to do this would be greatly appreciated.
Thanks.