I am try to adapt the Inventory Control database wizard supplied with MS Access. I have successfully adapted the tables and forms but I am having problems with the reports. I cannot find the control source for one of the existing objects.....I have looked in the tables, queries and forms but nowhere can I find the elusive "Units In Stock" control source . Where else might the control source be hiding?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Control Source
- Thread starter FletchUK
- Start date
If you look at the record source of the form its self, you will see that instead of being based on a table or query, it is based on an SQL statement. Click to the right of the line and the query builder will open. Units in Stock is defined as: Sum(nz([UnitsReceived])-nz([UnitsSold])-nz([UnitsShrinkage]))
Ed
Ed
- Status
Similar threads
- Locked
- Question
