Recent content by MHBear21

  1. M

    Command Find not working when Form is Subform

    John, the find button is in the subform not the main form. I am trying a find command on the Main form and was able to modify the SetFocus part of the code to: Me.subfrmNew_Invoice.SetFocus Me.subfrmNew_Invoice!Invoice_No.SetFocus Now it looks in the right place, but no matter what value I...
  2. M

    Command Find not working when Form is Subform

    Hello, I have a command button to find an invoice number that works the way it should when I test it a single form. When the same form is moved to a subform of another form the find dosen't seem to do anything. I get the Msgbox and can input the number but then it just sets the focus to the...
  3. M

    Open Form to a Combo Box on another Form

    Gina, sorry I'm not sure I understand where I am not putting in the right fields. I have tried this code in both the Contract_Number and Contract_Data_ Id fields with the same error. DoCmd.OpenForm "frmInvoices", , , "[cboContractNo]=" & Me![Contract_Data_ID]
  4. M

    Open Form to a Combo Box on another Form

    No, I have not changed the bound column. The bound column is still the Contract_Data_ID. It is the link to a subform on the frmInvoices so I don't want to change it.
  5. M

    Open Form to a Combo Box on another Form

    Gina, thanks for the help. I have tried the below, Number to Number, and am still getting the same error Enter the Parameter value on cboContractNo then nothing comes up. DoCmd.OpenForm "frmInvoices", , , "[cboContractNo]=" & Me![Contract_Data_ID] If I try and select a value in the combo I...
  6. M

    Open Form to a Combo Box on another Form

    The combo box is as follows: cboContractNo Contract_Number Column 1 - Text field (Only visible column) Contract_Data_ID Column 2 - AutoNumber (Bound Column Hidden)
  7. M

    Open Form to a Combo Box on another Form

    Here is the code I put in, but I am getting a Enter Parameter Value on cboContractNo, but when I enter the Contract Number it opens the form blank. When I select a record from the combo box the error "Run-time error '37093: The search key was not found in any record. I can hit the end and it...
  8. M

    Open Form to a Combo Box on another Form

    I am creating a dashboard and would like to put an event in the "On Dbl Click" that will open up the details to a second form. The second form is unbound with a combo box used as a filter to a subform. The first form is subfrmInvoiceDB with the fields built from a query: Contract_Number- Text...
See more
Back
Top Bottom