|
| |
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
 |
Yes/No Field - 7/13/2006 17:16:00
Hi,
I created 2 different table
Table1:
Datatype:
Field1: Text
Field2: Text
Select: Yes/No
Table2:
Datatype:
Field1: Text
Field2: Text
And then, I create a query to match up the fields of the 2 tables: Field1, Field2.
The output results are Field1, Field2, Select values from Table1.
But, I cannot check mark of the "Select" field value in the query, it doesn't work.
How can I make it works?
Thanks.
|
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Yes/No Field - 7/13/2006 17:45:41
Here is an excellent resource for those using MS Access:
http://www.access-programmers.co.uk/forums/
The query is just a display query, you cannot alter the values. You can't check or uncheck the checkbox nor can you change the values in Field1 or Field2.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
