I have a main menu that inturn fires a subform when a button is pressed, the subform has a query behind it. I would like to be able to lock the form bases on a date that the query returns. I currently have some code to turn allowedits on or off based on the date. But for some reason the form when it displays it is still editable. I have stopped the form and made sure that the allowedits is being turned off and it is, but somewhere it's being reset. Can anyone give me some help with this. Thanks in advance. Thanks Travis.