Solved

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

Posted on 2011-03-25
13
377 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
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now