Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005

    Unanswered: Selecting in Forms

    Hi, i'm new to using access forms and am experiencing some trouble trying to select a record and display it.
    In my form i have a textbox where i enter an order number, then when i click a submit button i want to search a table for this record and if it finds it, then display the records 2 fields.

    Any help would be great.... thanks guys

  2. #2
    Join Date
    Mar 2007
    Assuming the table/query you are searching is the RecordSource for your form then let the wizard help you put a ComboBox on your form that will "look up a record". Then look in the AfterUpdate event of the new ComboBox for the code you need to get your Submit button to work.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

Posting Permissions

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