Hi - (This is my very first post)
I have gotten to this point of registering to post because I have been
spinning my wheels so long, I believe I am all caught up in the weeds.
(and mud)
I have a form, that has several tabs. On one tab, I have a subform
(wr_completion_subform). This subform is bound to a table
(wr_completion_table).
On the subform, I have a button from which I have added code to email
a report of the completion data to our wr completion mailbox.
(wr=work request).
I also prefill many of the controls with information from the other
tabs.
If the user clicks on any of the controls in the subform, the table is
updated.
However, if the user accepts all the prefilled info and clicks the
'email' button, a blank report generates (no record on table to
report).
I saw a very similar post from 10/01 where the developer was advised
to use the me.dirty = false and the me.refresh. I have tried this and
other methods I have stumbled upon in the usenet group. Nothing seems
to work.
The table is bound to the subform, but I still added sql to check for
the record existance and if not there, SQL to insert else SQL to
update. I thought a manual insert or update would get around it - it
does not.
One clue: I read somewhere where the record selector will turn to a
pencil if it needs to be updated and will be an arrow if nothing to
update. I turned the record selector on in my subform and noticed it
was an arrow before submitting the report and a pencil after
submitting the report. (was not dirty until sometime AFTER the button
was clicked).
Please - If anyone has any wisdom, I would greatly appreciate it. I
need to be rolling out the product next week. (3/03/04)
Thank you in advance.