Hi there yet another question for you.
Does anyone know how to make a button on click send the record data contained in the current form??
many thanks
Printable View
Hi there yet another question for you.
Does anyone know how to make a button on click send the record data contained in the current form??
many thanks
DoCmd.SendObject acForm, (other parameters follow, like recipients, etc)
Although I've never sent a form, just tables. I don't know if it would send a visual representation of the form.
Usually what I do is to build a string from the data and then use .SendObject acNoObject, ....
The DoCmd.SendObject acForm may end up sending all the records of the forms recordsource.
If you need just one then do like salvinas posted.