Unanswered: How do I write a macro that opens up the single form data upon AfterUpdate?
How do I write a macro that opens up the single form data upon AfterUpdate?
My first entry field is called ID# on the form. So, supposedly I am entering
a new data entry, as soon as I entered the information for ID# (which is
AfterUpdate), I would like to open up the file that will having matching ID#.
So, how do I write a macro that will open up a form that already contains the
ID#? If it does not that ID# already in the database, then I don't want that
macro to run.
VBA is far more powerful and can do almost anything after updating any field or after saving a record. VBA can also interrogate the file system to find the file and if not found, do nothing else open the file.
I just realized what you meant in the other post that I made Yeah, search form is working great. I used a search form that goes through the query and look up for that entry and opens up in a database view window. Though I still need some enhancement.. I have a quick question if you do not mind me asking. My search form opens up a query with the database information in Database View. Is it possible that... once the search is performed, instead of open up the entry information in Database View, can it be opened up in a Form view? Thanks.