Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2014
    Posts
    17

    Unanswered: Making data from the form appear in the table.

    Hello,

    Please find the form attached.

    When entering the information into the form, i want the surname from the form to automatically appear in the table below the form?

    I am really unsure how to do this? is it something that i would need to change with the relationships?

    Some help would be greatly apprecitaed.

    Thanks.
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2003
    Location
    London
    Posts
    341
    Your subform needs to have a query assigned to it which selects values based on the surname typed in. Something like...

    Code:
    SELECT *
    FROM Table1 
    WHERE Surname = [Forms]![FormName]![FormItemName]
    You also need an event procedure after you update the SURNAME so using the ON UPDATE event

    Code:
    Private Sub SURNAME_AfterUpdate()
    
    Me.SUB_FORM_NAME.Requery
    
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •