Results 1 to 5 of 5
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Form Data Entry (A2k SR1)

    A form is setup for data entry. Form type is continuous. (Actually, the form is a subform to a subform). The recordsource contains a date field and is ordered descending so the most current entry is always on top.

    Here's the question. When entering data, the data entry occurs at the bottom of the form (i.e., the next available record) which isn't available for view after several records are input. Is there an easy or any way to set the form such that the data entry occurs at the top of the form and keep the form type as continuous? Just curious.
    Regards,

    Gary
    (It's been a while!)

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Form Data Entry (A2k SR1)

    There really isn't a simple way to do it. It would be nice if MS would come up with a way to do that in a standard form or subform, as we've hit that problem a number of times. The solution we've chosen to use involves two sets of controls - one for displaying (or editing) existing records that comprise a bound continuous form, and a second set of controls that are unbound where we use ADO or DAO to add records. We specifically disallow data entry in the continuous form to prevent people from doing unexpected things. It's a bunch of work, but will accomplish your objective.
    Wendell

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Form Data Entry (A2k SR1)

    Thanks Wendell. I didn't think there was a way, however, I figured someone here might have a good and easy work around. I have typically completed data entry in a manner similar to that you mentioned so data was not entered directly into the main form.

    It sure would be convenient if Microsoft could develop this control so data entry would be at the top of the form.

    Thanks for the information.
    Regards,

    Gary
    (It's been a while!)

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

    Re: Form Data Entry (A2k SR1)

    If that were implemented, the form would have to requery after every new record in order ot keep it at the top. That would make Access even more of a CPU hog than it already is. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Form Data Entry (A2k SR1)

    No, all we are trying to do is to change the form logic and reverse what the form does currently, that is add a record at the top and slide everything down the continuous form as opposed to adding the record at the bottom of the form and sliding all records up one.
    Well that's my logic anyway.
    Pat

Posting Permissions

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