i want to get data (liftno,model)etc in a subform by selecting a combo in main form .the subform data is from another table and in the main form cc field is from other table
LiftNo.RecordSource = "SELECT Proj_d.LiftNo, Proj_d.Model, Proj_d.Capacity, Proj_d.Capacity, Proj_d.Speed, Proj_d.Stops FROM Proj_d WHERE proj_d.LiftNo=Forms!material_imports!cc"
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!