Hi,
First here is the background of the problem:
This is an inventory database. There is a table with all the required fields, I then made a form based on the information. Then there is a query based on 2 tables in which is the subform.
In the subform I have 3 fields that add the collection of data I need to figure out how much is in stock. on order and available. The main form only reads from the subform.
The table is showing the numbers, but when I made a report it does not grab the data.
I have tried sourcing the subform, mainform, and the table fields, but it comes back with either # Error, or # name?
Does anyone have any ideas?
Thanks,
Stephanie
First here is the background of the problem:
This is an inventory database. There is a table with all the required fields, I then made a form based on the information. Then there is a query based on 2 tables in which is the subform.
In the subform I have 3 fields that add the collection of data I need to figure out how much is in stock. on order and available. The main form only reads from the subform.
The table is showing the numbers, but when I made a report it does not grab the data.
I have tried sourcing the subform, mainform, and the table fields, but it comes back with either # Error, or # name?
Does anyone have any ideas?
Thanks,
Stephanie