Hi, I was trying to get some help on how to create a form where you chose a record from a table and then you can fill with values on the "line headers" from another table.
It's like a cross-reference query, but instead of doing some grouping you can fill the value, and the 1st row you select what field you want, and inte the lines you put the values from the fields of another table.
It's 3 tables: table1 has a ID PK, table2 has a ID PK and table3 has the 2 PKs and a field.
In the primary form you select one record from table1 with a combobox.
Then the subform has a recordset of table3 and you can enter the value for the field.
But instead of picking the ID from table2 with a combobox, I wanted to display all ID's from table2 so I can just enter the value on the field.
I tryed a continous form, but it gets errors. You cant put subforms in continous forms...
Maybe there's some VBA where you need to create blank rows? But Isn't that bad? Having black rows?
It's like a cross-reference query, but instead of doing some grouping you can fill the value, and the 1st row you select what field you want, and inte the lines you put the values from the fields of another table.
It's 3 tables: table1 has a ID PK, table2 has a ID PK and table3 has the 2 PKs and a field.
In the primary form you select one record from table1 with a combobox.
Then the subform has a recordset of table3 and you can enter the value for the field.
But instead of picking the ID from table2 with a combobox, I wanted to display all ID's from table2 so I can just enter the value on the field.
I tryed a continous form, but it gets errors. You cant put subforms in continous forms...
Maybe there's some VBA where you need to create blank rows? But Isn't that bad? Having black rows?