Any Access Web App 2013 Guru's?

[2ilent8cho]

Been tasked with converting something done currently with endless paper to electronic , so decided an Access Web App should be the easy route as its web based and end user device neutral.

 

Almost got it working , but i cannot figure out how to filter the records. Once they have been 'Completed' and the check box 'Completed' has been ticked i no longer want them to appear on the far left on the screen shot. I can do an onload macro and tried the RequeryRecords with [QR_Students].[Complete]=1 but does not seem to do anything.

 

 

Any idea on the syntax to filter records against if a tick box is ticked or not? If it was normal Access i think it would be easier, but the Web App version seems to act quite differently.