Search results

If it were me I would be hitting tab after editing the first and leave the cursor in the second textbox before hitting the button, thus the second textbox would not update in the underlying value as in the detail it is still selected and the button would have to be in the header or footer...

You could use a union query. Something like Select .... from .... where .... Union all select .... from ..... where .... Which will give you what you want with the fields being named for the first select query.

I am developing a database to be installed on computers used by let's say unsofisticated users who work for any of 20 some odd companies. They need to send an email back with a generated multi-sheet excel spreadsheet that I create through access. From all the MAPI and CDO posts I have seen my...