Change field form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table which contains a field with a true or false statement {not primary}, i have made the form to enter the values and i want to find out how i can have another form to show only those records that have the False value so in the future i can change this field {i don't care if this is the only field i could change} to the True value....
i tried to do a query {implement a period also as a parametre lets say a month} it worked fine but i can't change nothin
is there a way to do it
Thank you for your time,
Sotiris_s
 
Select * From MyTable Where MyBoolField = False;

MyTable = Your table
MyBoolField = your Ture/False field
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

sotiris_s said:
I have a table which contains a field with a true or false statement {not
Click to expand...
primary}, i have made the form to enter the values and i want to find out
how i can have another form to show only those records that have the False
value so in the future i can change this field {i don't care if this is the
only field i could change} to the True value....
i tried to do a query {implement a period also as a parametre lets say a
Click to expand...
month} it worked fine but i can't change nothing
 
Back
Top