Search results

  1. A

    Filter a subform combo based on data from the main form

    Hi again, thank you so much for taking the time cheekybuddha and Pat Hartman. Unfortunately it did not work. I got a list of all products from all clients. I deleted the event in After update. Put ReceiveID in the Linkage Master/Child. There are 7 tables involved with this form. MF - Client...
  2. A

    Filter a subform combo based on data from the main form

    Private Sub ClientID_AfterUpdate() Dim SQL As String SQL = "Select ClientID From ClientT Where ClientID=" & Me.[cboClientID] Me.ProductReceiveSF.Form.RecordSource = SQL Basically I am of the understanding that this code will 1. update the combo of the SF with clientID and hence clientcode. I...
  3. A

    Filter a subform combo based on data from the main form

    So SF record source is TransactionT. Pic attached. SF Combo is cboProduct, control source is TransProductID, row source is blank (controlled by MF combo called cboClientID. cboClientID is populated with alphanumeric data. when this box is filled with a ClientCode, this client code is used to...
  4. A

    Filter a subform combo based on data from the main form

    Have a look at the screen grabs the first one shows the form and subform. the next one is the one field i am trying to use to control the contents of the sub form. the third is the field the main form controls. for the 1. I removed the linkage. on 2 I retained the linkage which was automatic...
  5. A

    Filter a subform combo based on data from the main form

    cheekybuddha thank you for the reply I tried your suggestion, though I still get a blank in my subform combo. Also do i need to use the parent form name, I was of the understanding the ME. was the parent. But I tried both ways. When I put me.addreceiveF.cboclientID I got an error saying cannot...
  6. A

    Filter a subform combo based on data from the main form

    It seems like I am missing something in one of these codelings. I get different errors depending on what I change in the Where section. 1. Private Sub ClientID_AfterUpdate() Dim SQL As String SQL = "Select ClientID From ClientT Where ClientID=" & Me.[cboClientID]...
Back
Top Bottom