Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Change in form's recordsource resets allow-additions to true

Posted on 2011-03-25
13
392 Views
Last Modified: 2012-06-27
Every time I change a form's recordsource -- the form resets to Allow Additions = true

Why does this happen? When I go into design view Allow Additions = false
0
Comment
Question by:Ei0914
  • 4
  • 4
  • 3
  • +1
13 Comments
 
LVL 75
ID: 35218352
"When I go into design view Allow Additions = false"
Sorry I'm confused. Then where do you see True ?

mx
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 35218439
I've never encountered that.

Are you seeing this because you are displaying the navigation buttons?  What indication are you getting on the form that the AllowAdditions is true?

0
 

Author Comment

by:Ei0914
ID: 35218476
I have a frame  control with options for the user to choose the recordsource (a query against the same table with different criteria) -- and it works great, except that when they make a change, there is suddenly a new record line in the continuous form. In design view the Allow Additions setting is False. I don't have code making a change to it either.
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 167 total points
ID: 35218529
In general, from a performance standpoint, you would be better of not changing the Form Recordsource, instead resetting the Form Filter with your option buttons - against the same recordsource

Me.Filter = <SomeCriteria>
Me.Filter=True

However ... for the moment, try - in your option group adding:

Me.AllowAdditions = False

mx
0
 
LVL 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) earned 166 total points
ID: 35218540
If it is the same query, why are you changing the recordsource?  Instead, just use the Filter property of the form.

Private Sub og_FilterCriteria_AfterUpdate()

    if me.og_FilterCriteria = 0 then
        me.Filter = ""
        me.FilterOn = False
    Elseif me.og_FilterCriteria = 1 then
        me.Filter = "[Field1] = 'Some value'"
        me.FilterOn = True
    Elseif me.og_FilterCriteria = 2 then
         me.Filter = "[Field1] Like '*SomeValue*'"
         me.FilterOn = true
    End if

End Sub
     
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 35218550
I hate it when he does that!
0
 

Author Comment

by:Ei0914
ID: 35218602
I can use a filter ----  but some of the criteria was hairy -- so I thought it'd be easier this way instead of a bunch of ands and ors, etc....

I still don't see how it's happening though...

I hate when it does that too!
0
 
LVL 75
ID: 35218760
Does seem odd.
But I would fly with the filter approach if possible.

Each time you change the Form's Recordsource, Access has to re-bind all the bound controls, as well as other overhead.   Filter is the elegant way.  But I know what you are saying about hairy criteria!

mx
0
 
LVL 16

Expert Comment

by:Sheils
ID: 35218844
<I can use a filter ----  but some of the criteria was hairy -- so I thought it'd be easier this way instead of a bunch of ands and ors, etc....>

Sounds to me like a candidate for Query by Form(QBF). The following website have a good example of QBF. It is a bit hairy if you are new to vba and sql but w can guide you through.

0
 

Author Comment

by:Ei0914
ID: 35219000
I didn't see a link to the website??
0
 
LVL 75
ID: 35219012
Stick with the Filter :-)

mx
0
 
LVL 16

Assisted Solution

by:Sheils
Sheils earned 167 total points
ID: 35219070
Opps! A little bit absent minded, still early in the morning. There it is:

http://www.fontstuff.com/access/acctut18.htm

Whether you use it or not should depend on the complexity of your query.
0
 

Author Closing Comment

by:Ei0914
ID: 35219354
Thanks, as always!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question