A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Questions check boxes from new Access user



 
 
Thread Tools Display Modes
  #1  
Old April 25th, 2008, 09:17 PM posted to microsoft.public.access.forms
Flashjw
external usenet poster
 
Posts: 2
Default Questions check boxes from new Access user

I have just created my first Access database and form. I have a problem with
the check boxes. When I am in record #1 and check the applicable box, it
stays checked in all the other records. So when I change the check box to the
applicable one for record 2, that becomes checked in all records.

How do I format my checkboxes (I have 10 of them) so that checking them in
record 1 only checks them in record 1, instead of checking them in all of the
records?

I have 10 check boxes, and in some records, as many as 8 of them need to be
checked; in some records, only 1 needs to be checked. Is there a better way
to do this other than check boxes?
Ads
  #2  
Old April 25th, 2008, 10:00 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default Questions check boxes from new Access user

"Flashjw" wrote in message
...
I have just created my first Access database and form. I have a problem
with
the check boxes. When I am in record #1 and check the applicable box, it
stays checked in all the other records. So when I change the check box to
the
applicable one for record 2, that becomes checked in all records.

How do I format my checkboxes (I have 10 of them) so that checking them in
record 1 only checks them in record 1, instead of checking them in all of
the
records?

I have 10 check boxes, and in some records, as many as 8 of them need to
be
checked; in some records, only 1 needs to be checked. Is there a better
way
to do this other than check boxes?



From the sound of it, your check boxes aren't bound to any field in the
table. If you want to store the state of a check box for a particular
record, you must have a Yes/No field in the form's underlying table (the
form's RecordSource) to hold that state, and you must bind your check box to
it by setting the check box control's Control Source property to the name of
that field.

Any control that is unbound -- that is, with a blank Control Source -- will
have the same value for all records on your form. It's the ControlSource
that binds the control to a particular field in the form's current record.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

  #3  
Old April 25th, 2008, 10:05 PM posted to microsoft.public.access.forms
Steve Schapel
external usenet poster
 
Posts: 1,422
Default Questions check boxes from new Access user

Flash,

This would imply that the checkboxes are *unbound*, i.e. if you look at
their Record Source property it will be blank. Is that what you intend,
or are these checkboxes meant to be linked to fields in the form's
underlying table?

Having said that, 10 Yes/No fields like this means it is also likely
that your table design could be improved. Someone will be able to
advise on this aspect if you can give more details of the data you are
working with, and the meaning of the checkboxes.

--
Steve Schapel, Microsoft Access MVP

Flashjw wrote:
I have just created my first Access database and form. I have a problem with
the check boxes. When I am in record #1 and check the applicable box, it
stays checked in all the other records. So when I change the check box to the
applicable one for record 2, that becomes checked in all records.

How do I format my checkboxes (I have 10 of them) so that checking them in
record 1 only checks them in record 1, instead of checking them in all of the
records?

I have 10 check boxes, and in some records, as many as 8 of them need to be
checked; in some records, only 1 needs to be checked. Is there a better way
to do this other than check boxes?

  #4  
Old April 25th, 2008, 10:11 PM posted to microsoft.public.access.forms
Flashjw
external usenet poster
 
Posts: 2
Default Questions check boxes from new Access user

I have tried to do that but I guess I'm doing something wrong, because now I
can't even check the boxes - they are grayed out on the form and won't check.
Can you give me step by step instructions? I'm not altogether sure I
successfully created a Yes/No field (I think I did) and I am more sure that
the problem is that I did not bind the check box to the field correctly.

Any step by step help would be greatly appreciated! Thank you so much!

"Dirk Goldgar" wrote:

"Flashjw" wrote in message
...
I have just created my first Access database and form. I have a problem
with
the check boxes. When I am in record #1 and check the applicable box, it
stays checked in all the other records. So when I change the check box to
the
applicable one for record 2, that becomes checked in all records.

How do I format my checkboxes (I have 10 of them) so that checking them in
record 1 only checks them in record 1, instead of checking them in all of
the
records?

I have 10 check boxes, and in some records, as many as 8 of them need to
be
checked; in some records, only 1 needs to be checked. Is there a better
way
to do this other than check boxes?



From the sound of it, your check boxes aren't bound to any field in the
table. If you want to store the state of a check box for a particular
record, you must have a Yes/No field in the form's underlying table (the
form's RecordSource) to hold that state, and you must bind your check box to
it by setting the check box control's Control Source property to the name of
that field.

Any control that is unbound -- that is, with a blank Control Source -- will
have the same value for all records on your form. It's the ControlSource
that binds the control to a particular field in the form's current record.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

  #5  
Old April 25th, 2008, 10:24 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default Questions check boxes from new Access user

"Flashjw" wrote in message
...
I have tried to do that but I guess I'm doing something wrong, because now
I
can't even check the boxes - they are grayed out on the form and won't
check.
Can you give me step by step instructions? I'm not altogether sure I
successfully created a Yes/No field (I think I did) and I am more sure
that
the problem is that I did not bind the check box to the field correctly.

Any step by step help would be greatly appreciated! Thank you so much!


Please post the RecordSource property of the form and the ControlSource
property of each of the check boxes. The properties are listed (with a
space between "Record" or "Control" and "Source") on the Data tab of the
form or control's property sheet in design view.

If the Recordsource is the name of a table, please briefly list the names
and data types of the fields in that table. If it's a query, whether the
name of a stored query or an inline SELECT statement, please post the SQL of
that query.

I'm going out now and probably won't be able to reply until sometime
tomorrow. It may well be that someone else will be able to use the info you
post to solve your problem before then.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:33 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.