M
Mary
Hello
I set up a data-entry subform that when you double click
in a field it opens another table. What I would like to
do is have the value on the "clicked field" on the
subform lookup the value on the table and bring the user
to that field on that table. I tried dlookup function and
it never opened to that record. Not sure if that makes
sense to design that way. The other element is that if
the "clicked value" is not existent in the table then to
move to the last record to add that value to the table.
((Would it make better sense to make the double click
event open something other than a table directly? I hope
the answer is no because it works so expeditiously))
Thank you in advance. Once again.
Mary
I set up a data-entry subform that when you double click
in a field it opens another table. What I would like to
do is have the value on the "clicked field" on the
subform lookup the value on the table and bring the user
to that field on that table. I tried dlookup function and
it never opened to that record. Not sure if that makes
sense to design that way. The other element is that if
the "clicked value" is not existent in the table then to
move to the last record to add that value to the table.
((Would it make better sense to make the double click
event open something other than a table directly? I hope
the answer is no because it works so expeditiously))
Thank you in advance. Once again.
Mary