Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bound vs Unbound forms

    Can anyone explain the pros and cons of using unbound forms vs bound forms? Do you get better performance than simply building a form based on a table/query. Does anyone have reading suggestions on this subject?

    Thank you kindly,

    TheProfessor

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bound vs Unbound forms

    Hi Professor,

    I'm sure others will have more to say on the subject, but here's my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15> :

    For most situations, using a Bound form is the best way to go. Trying to write all of the code to control data entry and editing on an unbound form would be a waste of time (in most cases). Bound forms are one of the features that make working in a DBMS (Database Management Stsyem), like Access, so quick and easy. Using unbound forms for everything would be almost like trying to write a Database application in Visual Basic.

    As for performance, I doubt there's any substantial difference for most situations (especially for recordsets based on one table, or a query with just one or two tables).

    To put it another way, (bearing in mind that there are occasional exceptions) using unbound forms in Access is like putting your car in Neurtal and pushing it down the freeway. Using bound forms is like starting the engine, putting it in gear and pressing the accelerator!
    Bottom line: The engine is there, why not use it? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

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

    Re: Bound vs Unbound forms

    Actually, if you use ADO recordsets in Access, you don't have any choice. Access forms bound to ADO recordsets are not editable, so they can't be used for data entry or editing. The only option if you want to populate a form from an ADO recordset is to use an unbound form. The code isn't all that burdensome and can be copied and pasted into most of your unbound forms.

    Even with DAO, it is sometimes necessary to use unbound forms. For example, if you are capturing test answers and the form contains controls for each question and answer but you want each answer to be a separate record in an Answers table, you will have to use an unbound form and have code create a record for each answer.

    Unbound forms allow you to postpone locking a record until you're ready to write it, so they have advantages in multi-user environments. They also provide a means of protecting your data from accidental damage from the user who hits enter keys without paying attention to what is highlighted, and there is no way for the user to accidentally navigate to another record because all that is controlled by the form itself.

    Overall, there are plenty of reasons to use unbound forms, but it depends on the particular situation you need to address. Bound forms are quick and easy and they automatically take advantage of the built in relational features of Access, but they are not the optimal answer in every situation.
    Charlotte

  4. #4
    Lounger
    Join Date
    Jan 2001
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bound vs Unbound forms

    Many thanks Charlotte,

    That's exactly what I was looking for. Do you know if there are any Tome's on the subject?

    Thanks in advance,

    TheProfessor

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

    Re: Bound vs Unbound forms

    I haven't seen any, but there are plenty of knowledge based articles and this is covered in every book on Access that I've seen.
    Charlotte

  6. #6
    Lounger
    Join Date
    Jan 2001
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bound vs Unbound forms

    Have you built any databases used on a network? Have you ever tried unbound forms for anything?

    Thanks in advance

    TheProfessor

Posting Permissions

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