Recent content by coopah

  1. coopah

    Next Record after changing a sorted field

    DLOOKUP in a Function? RG, were you implying that I should look into using a DLOOKUP in a module to get the value of a field from another table? I've been experimenting with just DLOOKUP in an unbound text box...still playing with it to see if I can get what I need. Still believe I'm going to...
  2. coopah

    Next Record after changing a sorted field

    Wow, I'm Impressed RG! You anticipated that I would forget the BeforeUpdate Event <teehee>. :o Both NEXT and PREVIOUS are working great! BIG Thanks once again. I'm researching the DLOOKUP thing. I experimented with a list box, instead of the combo box to show the projects. That will work...
  3. coopah

    Next Record after changing a sorted field

    Previous button is gettin' me now RG, Thanks again! I'm working on the sub-form now. Adding a sub-form seems like a lot just to get the value of three fields from one table to display with a form based on another table...but what do I know :p I have to ask though, is there another way (maybe a...
  4. coopah

    Next Record after changing a sorted field

    Project Numbers Explained :) Good Afternoon RG, Yes one project can relate to many individuals; and, one individual can be involved in many projects. The project numbers actually identify thousands of projects in a series. Project numbers also identify it as industry, scientific...
  5. coopah

    Next Record after changing a sorted field

    Too Perfect RG, you rock me dude! ;) Here I thought the code went inside a model object (something like the ajbcalendar). How embarrassing :o :o As for the projects table, it contains numbers that identify various government and industry contracts for scientific/medical research...
  6. coopah

    Next Record after changing a sorted field

    Rg, Here's part of the database I've been trying to figure out. This is a tiny subset of a much larger database I've been working on. The error is replicated in the attached file. One other problem you may be able to help me out with is the project numbers. You'll notice there are fields for...
  7. coopah

    Next Record after changing a sorted field

    Different Error..."Sub or Function not defined" RG, I recived another Compile Error:"Sub or Function not defined" and the text highlighted in the "Private Sub Form_BeforeUpdate(Cancel As Integer)" subroutine, I think for the "NextID = NextRecVal()" -Carol :eek:
  8. coopah

    Next Record after changing a sorted field

    RG, First, thank you for your patience, you're a doll! I did exactly as you said and received the error: "compile error: external name not defined" and this line was highlighted in yellow: "Function NextRecVal() As Long" -Carol [feel like crying]
  9. coopah

    Next Record after changing a sorted field

    Admitting Defeat on this... :( Hey RG and the rest of y'all, I tried the module thing (see it at the end of this post) and couldn't figure it out. I added a field on my form to show the primary key, "rec_id" (the key I need to search on later to go to the next record). Then I tried changing...
  10. coopah

    Next Record after changing a sorted field

    Thanks Rural. I looked at the MS page but afraid I don't understand it all. My table name is "people" and my form name is "personnel". The key field I need to search on is "rec_id". Beyond that, I don't know what else I'm supposed to put for "[ID]" in the two sets of brackets below...
  11. coopah

    Next Record after changing a sorted field

    Hi guys, I need a little help on next record stuff...:eek: Can someone please explain how I can make my database actually go to the "Next" record after I update the "LName" field on my form? My database is sorted on "LName". After I update the "LName" field and save the record, the sort...
Back
Top Bottom