Recent content by jighead

As I am looking at this again today, I notice that when I open the Object Browser, frmInvDetail is not listed as an object in my project. How do I get the Object Browser to see this form? I suspect that the type definition error is because the module knows nothing about frmInvDetail. I can...

The yellow arrow is pointing to: Function OpenFormInstance(FormName As String, Optional WhereCondition As String) but this is "selected": New Form_frmInvDetail

I've copied some code from the Access 2007 VBA examples for opening multiple form instances. It works when I open the example db, but gives me a "User-defined type not defined" when I use it. I have looked at the references from the example db, and made sure that I have VB for Apps, MS Access...

In your subform query, add criteria to the ContronNumber column for the value of the combo box, something like [Forms]![YourMainForm].[YourComboBox].[Value]. When the afterupdate event requeries the subform, it should only return what you are looking for.

I am working on an inventory project, and want to have a form where you scan a UPC into an unbound text box to initiate the check in and out of items. Because the UPC is not guaranteed to be unique for all of the unique items (sizing, series, kits, etc), I have the AfterUpdate of this control...

Yeah, if I only query the TransactionTypes table, and leave the InventoryTrans table out of the query, the list shows up However, the problem seems to be more than just this combo box. This combo box is part of a form that should record inventory transactions. I built the form from this...

I am new to Access and VBA, and am having a problem getting a combo box to work as expected. I have two tables: tblInventoryTransactions PK - TransactionID (autonum) ProductID (int) TransactionType (int) etc tblTransTypes PK - TypeID (autonum) TransactionName Action tblTransTypes is simply...