Hello,
I have a microsft access form which is pointed to a table with multiple records. I would like to add a command button to this form which will email current record results which are currently viewed on this form (one record at a time).
I have vba code using the cmd command which will open email, however, it will only send the first record in this table and not any other record, including the current record being viewed....
This would be similar to the docmd to print the current record on a form...instead i want to email.
I hope this makes sense....
Thanks!
I have a microsft access form which is pointed to a table with multiple records. I would like to add a command button to this form which will email current record results which are currently viewed on this form (one record at a time).
I have vba code using the cmd command which will open email, however, it will only send the first record in this table and not any other record, including the current record being viewed....
This would be similar to the docmd to print the current record on a form...instead i want to email.
I hope this makes sense....
Thanks!