Really stuck

[dc_uk]

im having some issues with my database which i simply can't get my head around.

Upon creating a driving school database, i did a lookup field for motoway lessons being 'N/A', 'Yes', 'No'. This could only be 'Yes' or 'No' after they pass their test otherwise set to 'N/A' by default.

Now i've set up a query, with all the fields from that table. I've already entered criteria for result being 'Pass' and upon doing this needs the value of 'Motorway' to be auto-set to No.

but can't work the formula

 

[snakeyes2002]

r u attempting to add a third "N/A" value to a combo box, if so..

put..

SELECT table.fieldname FROM table UNION SELECT "N/A" AS BOGUS FROM table;

in the rowsource of the combo box, replacing table with the table name and fieldname with the fieldname.

else if you're attempting to show this in a checkbox you could either set the checkbox 'locked' property to true on the AfterUpdate event of the combo if the value is n/a

there are several more ways.. could you expand a bit?