[AccessD] Looking for easy form solution

Rocky Smolin rockysmolin at bchacc.com
Sat Oct 24 17:37:08 CDT 2015


I always liked a few lines of code to do something myself.

What was in strFilter?

r 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of FW
Salato Center
Sent: Saturday, October 24, 2015 1:09 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Looking for easy form solution

I was totally abusing the whole thing -- I'm such a ditz. You said it, but
it didn't quite connect. Setting the Value property in code only changes the
first record instead of all of them because of course it's the selected
record. 

If I rely on the easy way -- the Yes/No at the table level (bound),
unselecting a record will change it at the table level, which is just more
trouble than it's worth. 

I should've gone the Recordset method in the first place. Talking in SQL has
always come easier to me anyway. 

<sigh> 

It's raining here and it's cold so I'm sure that played some measure in my
calamity. :) Sounds better than admitting I've forgotten everything I knew
and that I'm no longer competent in Access. That hurts. 

Susan H. 

Rocky, I did. 

First, I tried to set the default value at the form level. When you open the
form without filtering, the checkbox controls are selected. When I open the
form with a filter, they aren't. So, I tried setting them after opening --
still doesn't work. No error, it just doesn't do anything. 

  DoCmd.OpenForm "Medical Update by Species", , , strFilter
  Forms![Medical Update by Species]!booSelect.DefaultValue = -1

Susan H. 


Make the default value in the table False.  You may have to run a quick
update query one time to set the value of the added field to False in  the
existing records.  But all other records which are added should set that
field to false as default. 

r


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



More information about the AccessD mailing list