Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Oblvion

    Concatenate values of four TextBoxes into one TextBox

    i solved my own problem... Private Sub cmdBirthDateAutoFill_Click() MemberID = Left([Last], 1) & Left([First], 1) & Left([Middle], 1) & [BYear] End Sub
  2. Oblvion

    Concatenate values of four TextBoxes into one TextBox

    to concatenate first value from first 3 textboxes and year value from fourth textbox for LED1962 to display in MemberID textbox L from Littlejohn (txtlastname textbox) E from Eugene (firstname textbox) D from Dale (middlename textbox) 1962 from Year (birthyear textbox)
  3. Oblvion

    Populate Mainform with Subform Record

    OMG !!! I SOLVED IT... Private Sub cmdGoToChildRecord_Click() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[MemberID] = '" & ChildrenSubform.Form![MemberID] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark End...
  4. Oblvion

    Populate Mainform with Subform Record

    ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.findfirst "[MemberID] = '" & Me![Mother] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark The GoTo button to call my Mothers record. Can you code it to call a Childrens record that has...
  5. Oblvion

    Populate Mainform with Subform Record

    http://www.rrafnpowwow.com/database/database.jpg the image shows my GoTo buttons. the GoTo buttons work on the Mainform info of my Father, Mother and Spouse to show them. problem: for the GoTo button to show Children info that's in the Subform. All records use the same MemberID and same...
  6. Oblvion

    Populate Mainform with Subform Record

    I want to select a Subform record using the Record Selector, then click a GoTo button on the Mainform to populate the Mainform with that selected Subform record. All records are controlled by MemberID.
  7. Oblvion

    Microsoft Access find button on main form that searches a subform

    I am trying to double-click a Record Selector in my subform to populate the mainform with the same record. But I get Error Message 2465 'DATABASE can't find the field "|" referred to in your expression... ======================= Option Compare Database Option Explicit Private Sub...
  8. Oblvion

    Making a record from a subform the current record on a main form.

    I have the same problem and need to populate the mainform record with the subform record. The mainform and subform records all have the same 37 fieldnames, ie; MemberID in mainform is same as MemberID in subform. Father's name is in mainform and Children's names are in subform, like a pedigree...

Part and Inventory Search

Back
Top