Re: VBA not requerying form on not in list event
@moke123 Thanks for the link on the Option Explicit. I'll study up on that.
But I think we might be talking about the same thing when it comes to lookup fields.
Here's how my sql looks in one of my row sources for Tbl_BaseSku:
SELECT Tbl_ProductCategory.[ProdcutCategory_ID], [Tbl_ProductCategory].[ProductCatCode], [Tbl_ProductCategory].[ProductCategory] FROM Tbl_ProductCategory ORDER BY [ProdcutCategory_ID], [ProductCatCode], [ProductCategory];
If there's a different way to do this and get the same data with the same relationships then I don't know about it. If you were thinking I was using the Access Lookup Wizard and entering my list options directly into the table (I just call this embedding for lack of a better word), then no I'm not doing that.
And the attachments are images that I need to see in the interface, record by record.