I am working with 1 table called Orders. The two fields i am dealing with are Orderdate and Received.Right now I have an access 2007 Multiple Item form which is wizarded off a query from the Orders table with the criteria- Between [Start Date] and [End Date] , Received is null.
The Form shows all items matching this. I would like to attach a command button and a text box on this form in which i enter a date in the text box press a command button and the Received field from the orders table for the records displayed update to the date I entered.
Or if there is a differnent way I'm open ...but i prefer the first way.
Also I am very new to this so respond as simply as possible please
Thanks
Lance
The Form shows all items matching this. I would like to attach a command button and a text box on this form in which i enter a date in the text box press a command button and the Received field from the orders table for the records displayed update to the date I entered.
Or if there is a differnent way I'm open ...but i prefer the first way.
Also I am very new to this so respond as simply as possible please
Thanks
Lance