I have a question relating to subforms. I have a form1 from table1 and created subform1 using table2. Each table has a common field where it is linked.Now , I need to display a field from table2 in the form1?
If i make a combo box in form 1, it does not work . it just remains the same for all records?
Is this possible?
making a control in the main form with the table of sub form ?
Another question is ,
In the main form , i do have a primary key , when I enter the primary key , it should populate all the other details relating to the primarykey such as name of the object , date when measured, time when measured etc.
how do I do this ?
Please help.
hapr1
If i make a combo box in form 1, it does not work . it just remains the same for all records?
Is this possible?
making a control in the main form with the table of sub form ?
Another question is ,
In the main form , i do have a primary key , when I enter the primary key , it should populate all the other details relating to the primarykey such as name of the object , date when measured, time when measured etc.
how do I do this ?
Please help.
hapr1