I am still a new user so please no laughs...
I have Form1 where I can view product information. The form has its recordsource as Query1 which takes values form Products table. In addition to product info, each product also has associated costs (also in Products table). I want to create a subform that will show the costs for the current product. No matter how I try to create the subform, I am told that the table/query can't be locked out.
My basic question is, how can create a form with a subform that both take their information from the same table/query?
In case you are wondering why I need it this way, there are too many fields to show on one form. So I want to be able to see the costs "separately". Thanks in advance!
Marco
I have Form1 where I can view product information. The form has its recordsource as Query1 which takes values form Products table. In addition to product info, each product also has associated costs (also in Products table). I want to create a subform that will show the costs for the current product. No matter how I try to create the subform, I am told that the table/query can't be locked out.
My basic question is, how can create a form with a subform that both take their information from the same table/query?
In case you are wondering why I need it this way, there are too many fields to show on one form. So I want to be able to see the costs "separately". Thanks in advance!
Marco