N
nyitg
I am using Access 2007. I currently have a form that contains fields linked
to a subform (master-child). I use the right click short cut filter command
to search the database on the field in the form. The results show-up in the
subform. The only problem I have is when there are no results; both forms go
blank and I have to close and reopen the form. I have tried several bits of
code (Recordset=0 etc.) that I have picked-up from the forum, but to no
avail. Most of my co-workers really like the flexibility that goes with the
filter options when you right click, but some (including my boss) doesn't
like having to close and re-open when there is no match. Is there an easy way
to have a message box appear using the short-cut commands? I'm a newbie when
it comes to code, which is why I used the short-cut method to filter in the
first place and didn't develop a search form. thanks.
to a subform (master-child). I use the right click short cut filter command
to search the database on the field in the form. The results show-up in the
subform. The only problem I have is when there are no results; both forms go
blank and I have to close and reopen the form. I have tried several bits of
code (Recordset=0 etc.) that I have picked-up from the forum, but to no
avail. Most of my co-workers really like the flexibility that goes with the
filter options when you right click, but some (including my boss) doesn't
like having to close and re-open when there is no match. Is there an easy way
to have a message box appear using the short-cut commands? I'm a newbie when
it comes to code, which is why I used the short-cut method to filter in the
first place and didn't develop a search form. thanks.