NOTE on the screen if I enter the report number previously checked by someone else

[vazdajic]

Hello everybody. Before I post a question, I would like to write that I am a beginner at MS Access and I have zero knowledge at VBA programming..

While reading the text below please open a picture attached..



To most of you this might sound like a nonsense but please tell me how can I make Access show me a note on the screen every time I input report number which has been previously input by someone else. When that someone checked that report he has found some mistakes on it and before sending the report to be corrected, he has put a short description about what wasn't OK.

Now, after I input the same report number in the Form, I would like the Form to tell me in real time when that report was checked, by who, what was wrong etc...

Thank you so much..

[ranman256]

in the REPORT # combo box, in the events properties, under AFTERUPDATE event put this:

sub cboBox1_afterupdate()

me.Filter = cboBox1   (your combo box name)
me.FilterOn=True

then when you pick the # in the box, the form will show ONLY that #. (by filtering the data)
To unfilter, unclick the FILTER button on the top toolbar to see all the records again.

[vazdajic]

not working ((((

[vazdajic]

not working

I tried also:

sub cboBox1_afterupdate()


me.Filter = cboBox1 ([Combo90])
me.FilterOn=True

[vazdajic]

Maybe I haven't been clear..

After I enter a report number, I would like Access to show me in a separate text box, in real time, all previous inputs with that same report number.. Like in Windows Explorer, when in Search box of an indexed folder full of PDFs as I enter part of the name of a PDF I'm searching for, the list narrows and shows me all PDFs which in file name have criteria I have input..

[Bob Fitz]

What will you want to do with the results, just view them or will you want to do something like perhaps go to one of the records

[vazdajic]

I would just like to view the results.. In my database I can have one report for instance 5 times.. 4 times the same report was bad (with mistakes) so now when I am checking it for the fifth time I would like to see on the screen who has checked it 4 times before me, what were the mistakes so that this time when I am having it in my hands I can check only if those mistakes (found in previous 4 checks) were corrected. It means I don't have to check again the whole report and waste a lot of time...

[Bob Fitz]

Can you post a copy of your db

[vazdajic]

how do I upload the database?

(sorry for being dumb)

[Bob Fitz]

To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.

[vazdajic]

Database attached

[Bob Fitz]

Take a look at the attached db

[vazdajic]

Hi Bob.. I have downloaded the Zip file, unzipped it, linked it with DATA storage table ("Table") and the form doesn't work.. When I enter on purpose the same report number, the form doesn't tell me anything.. No info about previous input of the same report.. Hm..

[Bob Fitz]

what report number did you test with

[vazdajic]

I have tried with several reports which exist in the database.. When I enter the same report number (again) nothing happens.. I would like to see some kind of note on the screen if I enter the same report nr. again