How to change status

[jkemp]

I new to this and self teaching myself on access but have now come to a point that I can not seem to locate the answer.

I have set up a form that allows me to enter information on an item. This form is for initial entry, like an asset item. In this form I have a field for status of the item and the condition of the item.

Where I am having trouble is being able to bring the item up and change the status of the item if it is broke or damaged. I have the item as [label] and set as the primary key. and an item as [studentid] as a foreign key. I also would like to be able to query the different status'. I am confident I can set queries up but I need to figure out how to recall the [Label] change the [status] and save it. The only other thing that I could hope for is to track then number of times the [status] was changed.

Thank you in advance

 

[burrina]

Don't know how you have things setup but you could use a combobox to filter the form.
Access saves the data automatically either when you move to a new record or close the form.
As for the count, do a search on DCount
HTH