should be easier

[hatebreed]

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));

 

[Kraj]

I'm not positive, but what it sounds like is you are trying to update the record from within the subform. More often than not, you can't do this when the subform is based on a query. What I've done to get around this in the past is to add a botton that opens the form where you originally input the 'report' and filter it on the record key from the subreport. That way, you can fully edit the report but you don't have to search through all your records to find it. You can then add code to make the subform refresh when you close the edit form to remove the updated record form the list.

So, as far as I know it's not easy! But it is possible.