Recent content by accesskiddo

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...

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...

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...

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...

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...

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]...