Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DenverBadger

  1. DenverBadger

    Context-sensitive Access Forms: Selecting one record From Many

    I think I've solved it. Here are the changes I made: ------------------------------------------------------------------ This is a snippet from the code I posted earlier. The main change is instead of calling my datasheet form as a subform, I set the value of "Lans" to the specific AutoKey value...
  2. DenverBadger

    Context-sensitive Access Forms: Selecting one record From Many

    Turns out, our office has MediaFire blocked so I can't upload my files. I took some screenshots and was intending to reference elements in the screenshots and identify where in my code those elements come into play. Without the screenshots, I'll try to describe what is what instead. Also, since...
  3. DenverBadger

    Context-sensitive Access Forms: Selecting one record From Many

    The underlying tables are linked like this: Main Table (actual name "RTRMA") ???Serial (Field lookup to "EQUIPMENT" table) ? ??? Nominclature (Field lookup to "PARTS" table) ???SiteName (Field lookup to "SITES" table) The RTRMA table has six critical fields: RMA: The Return...
  4. DenverBadger

    Context-sensitive Access Forms: Selecting one record From Many

    Problem: User enters data in an unbound field in a form to locate a record but the data isn't descriptive enough to isolate a single record. (Database is for repairing equipment. User enters a serial number, but there are more than one instances of that particular piece of equipment coming in...
See more

Part and Inventory Search

Back
Top