Hi All,
I have multiple forms for entering different types of stock onto a database, when entering, a query looks up stock already on the database for that product. To make life simplier I want one query with the criteria for product something like:
unfortunatly it's not that simple and if one of the forms isn't open it can't locate and therefore throws up an error.
One thought is to open the other forms in the background and they'll return a blank then close them when the user has completed entering the stock, but this seems a like workaround rather than a clean fix. Is there a simple solution to avoid this error?
Many Thanks for any thoughts
I have multiple forms for entering different types of stock onto a database, when entering, a query looks up stock already on the database for that product. To make life simplier I want one query with the criteria for product something like:
Code:
[Forms]![frmStockEntry].[Product] Or [Forms]![frmStockEntryPreCompounded].[Product]
One thought is to open the other forms in the background and they'll return a blank then close them when the user has completed entering the stock, but this seems a like workaround rather than a clean fix. Is there a simple solution to avoid this error?
Many Thanks for any thoughts