Search results

Works perfectly except now my "OK" cmd on popfrmReassignGroupedTools doesn't work. It had previously worked. Could you look at that code for me? When I click "OK" nothing happens. The bolded portion is where the code stops running and it exits. Private Sub cmdOK_Click() On Error GoTo...

Thanks. SubForm Public Sub cmdReassign_Click() On Error GoTo ErrHandler Dim strOpenArgs As String strOpenArgs = Me.txtToolGroupID & "," & Me.txtEmployee_Name DoCmd.OpenForm "popfrmReassignGroupedTools", , , "ToolGroupID=" & Me.txtToolGroupID, , acWindowNormal, strOpenArgs...

Main form On Open Private Sub Form_Open(Cancel As Integer) Forms!frmToolReassignment_Combined!subfrmToolReassignment_Grouped.Form.cmdReassign.SetFocus Subform Command Button Public Sub cmdReassign_Click() On Error GoTo ErrHandler Dim strOpenArgs As String strOpenArgs =...

The control name is the same.

I have a main form with a subform. When I click on a command button located on the subform I get an Error 2450: cannot find the referenced form. The name of the subform is subfrmToolReassignment_Grouped, the source object is subfrmToolReassignment_Grouped and the name is...

Sub Form 2 Public Sub cmdReassign_Click() strOpenArgs = Me.txtToolGroupID & "," & Me.txtEmployee_Name DoCmd.OpenForm "popfrmReassignGroupedTools", , , "ToolGroupID=" & Me.txtToolGroupID, , acWindowNormal, strOpenArgs PopForm 1 Private Sub Form_Open(Cancel As Integer) If Not...

Hello. I have a main form (Form 1) that includes (2) subforms (Subform 1 and Subform 2). Subform 2 has a command button that opens PopForm 1 as a popup (VBA with use of OpenArgs). When Subform 2 is opened directly as the only form then the command button functions properly. When Subform 2 is...

Very similar I would imagine. Tools are identified by ID number, category, and description. I've enabled the filter to search by either tool ID number, too description OR tool location (employee who has been assigned the tool, storage or junk/lost)

Thanks. I can't figure out how to get the filter results to show up in the pop up.

Hi. I'm setting up a database to track company owned tools. I've created a split form with a filter based on a query that shows the complete inventory. What I'd like to do is after the filter has been completed, use check boxes to "select" multiple items from the inventory, then click a...

This code gave me the same results except now the text boxes "OSHA Write-Up" & "End Result" are visible with before the combobox update.

I have a combobox "ComboViolation_Performance" with 3 options, "Verbal Safety Warning", "Write-Up Safety Warning" and "OSHA Write-Up" & defaulted to NULL. When a specific item is selected two text boxes would become visible. "Verbal Safety Warning", "Write-Up Safety Warning", "OSHA Write-Up"...

:banghead: I have only been working with VBA for 1 week and I am stumped at this point. I have a form where I want 2 text boxes to become visible and enabled when a selection is made on a combo box. I am working in 2013. This is what I have. Private Sub...