Should Be Easier

i think this is prolly easier than im making it out to be.

first i will explain what im doing. this db is used to basicly have problem reports. when a person calls info is gathered and they are assigened a number by myself based on the company they are with. puts a timestamp and then the use of the db at that point is over.

but this is what i can't figure out.

I want to make a subform viewable on the same pane as the main form, that will search for the problem reports that don't have a timestamp on a completed column of the table the rest of the data is on. i can get it to pull what ones don't have a close date, but i can't get it to when i select/click/type in the number to add a timestamp, and erase it from the search. I hope this makes sence.

thanks for any help.

p.s. this is what i have so far to pull the data

SELECT history.issue_number FROM history WHERE (((resolved) is null));