Easy Form question

mlopes1

Registered User.
Local time
Today, 12:18
Joined
Sep 4, 2002
Messages
76
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 can't imagine why you are told that the table/query can't be locked out. I've never seen an error message like this.

You can create a form with a subform that are both based upon the same query. No trick to it...

If there are too many fields to fit onto one form, adding a subform won't alleviate this problem, seems to me...unless the subform has scroll bars, perhaps?
 

Users who are viewing this thread

Back
Top Bottom