Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006

    Unanswered: Open selected record to a new form

    Is there any easier way you can select a record from a continuous form and view in a separate form instead of appending it to a temporary table and pulling the record from there just like what I did below:

    strSQL = "INSERT INTO tmpRecord( tmpRecordNo ) " & _
    "VALUES (""" & Me!RecordNo & """);"
    CurrentDb.Execute strSQL, dbFailOnError
    myForm = "frmViewRecord" 'display to specified form
    myWhere = "RecordNo = '" & RecordNo & "'" 'to my unique key
    DoCmd.OpenForm myForm, , , myWhere, , , 2
    I would really appreciate the help. Thank you in advance!

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    What is the point of the temporary table? You can use the same technique to open the record in a new form:

    Open a second form to the record

  3. #3
    Join Date
    Nov 2006
    Thank you so much for your help. That saves me from creating extra tables. Thank you again pbaldy.

Posting Permissions

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