Results 1 to 6 of 6
  1. #1
    cvclubs is offline Novice
    Windows 7 Access 2007
    Join Date
    May 2010
    Posts
    5

    Help locating a record on click

    I am design a limousine dispatch database and it would really be benificial to me if I could do the following:

    I have a split form I use to make reservations and input all details. These details need to be changed often.

    There is a report that shows our reservation #'s as well as trip details. I want to be able to click the res # on the report and have it being me to that res# on the reservation form so I can edit the details.

    So far I go into design view right click the res# field go to properities and then build event. I do Open Form and then am lost from there (fairly new to access)



    Thanks!

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I've actually written a limo res/dispatch system, though that's irrelevant to this. Your simplest solution presuming the form is bound to the table is to use the combo box wizard, choosing the third option, "Find a record...". There's also this if I've misunderstood what you're doing:

    BaldyWeb wherecondition
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    cvclubs is offline Novice
    Windows 7 Access 2007
    Join Date
    May 2010
    Posts
    5
    I guess the easiest way to put it is that when a record shows up on a report i would like to be able to click a record and be taken back to that record in the form so I can edit it.

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Sounds like you want the technique in the link then.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    cvclubs is offline Novice
    Windows 7 Access 2007
    Join Date
    May 2010
    Posts
    5
    Where do I enter that? I am sorry I am very new to this. This is what it should look like?

    DoCmd.OpenForm "Reservations, Kelly", , , "Res # = " & Me.ControlName

    Reservations, Kelly is the form name
    Res # is the field in which I want the record is based upon

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It would go here:

    http://www.baldyweb.com/FirstVBA.htm

    "ControlName" would be changed to the name of the control (textbox, combo, etc) containing the reservation number. If you really have the inadvisable space and symbol in the field name, it will need to be bracketed:

    [Res #]
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 07-22-2011, 12:52 PM
  2. Save record to 2 tables on one click
    By chin1383 in forum Forms
    Replies: 1
    Last Post: 04-01-2011, 12:49 PM
  3. Replies: 9
    Last Post: 12-18-2010, 12:51 PM
  4. Replies: 1
    Last Post: 05-31-2010, 05:18 PM
  5. Click a record to display it for edit
    By mapl in forum Access
    Replies: 0
    Last Post: 11-24-2008, 03:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums