Recent content by cburgess

  1. C

    Using IIF statement for a command button "on-click"

    Thank you for your assistance. I have ended up using the requery function: Private Sub Command17_Click() Select Case Me.txt1 Case "C": Forms![frmCompany]![C_Address1] = [Address1] Forms![frmCompany]![C_Address2] = [Address2] Forms![frmCompany]![C_Town] = [Address_Town]...
  2. C

    Using IIF statement for a command button "on-click"

    Thank you, this works well.. One more thing - with the first case, it updates on the second form straight away but when I add the second case it only updates once the form is closed or refreshed etc. Is there any reason for this? My code now looks like this: Private Sub Command17_Click()...
  3. C

    Using IIF statement for a command button "on-click"

    I have a form with a command button. At the moment when I click the button it inserts text from the form onto another form. This all works fine. I am now looking to extend the functionality of adding an IIF statement to this button so that I can use this one form to insert text to many...
  4. C

    Query based on multiple Many-To-Many Relationships

    Hi, I am currently building a system which uses many-to-many relationships. The basic layout is: tblCompany and tblAddress with the Company having a "Registered Address" and a "Correspondence Address".. therefore I have two m2m relationships in order to save having multiple Address tables...
See more
Back
Top Bottom