Search results for query: *

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

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)

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

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

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

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.

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

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