Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Select Record from Data Sheet (A2k (9.0.4402) SR-1)

    Select Record from Data Sheet

    A2k (9.0.4402) SR-1

    I have a main form (full screen) that opens and positions itself on the last record in the table.

    I have a button on the form that opens the same table with a data sheet form showing the last 20 records or so.

    I want to be able to click on the Account Number field of the data sheet record and have the system open the main form on the data sheet record selected.

    I need the code for the data sheet Account Number double click event to position me on the correct record with the main form..

    Thanks, John Graves

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Select Record from Data Sheet (A2k (9.0.4402) SR-1)

    Using DAO or ADO? You have the current record in the datasheet, so you can refer to the controls that hold the keys you're going to want to find on the main form. Then all you have to do is find them in the form's recordset. If you use DAO, you can use recordsetclone navigation. If you use ADO, you do a find in the form's recordset.
    Charlotte

Posting Permissions

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