Records change in subform!!

[Sam Gledhill]

Hi, I'm hoping someone can help me out. I have a database with a
form. This form has no recordsource (I'm using it as a complex
MsgBox). It has a single textbox of type Date. It also has three
unrelated subform that are filtered according to the date entered in
the form's text box. By using after update events, I've been able to
allow users to change the date in the textbox and alter records from
the day throughout three other tables.

The problem arises when you close the form. It appears that the form
will alter the first record of the table linked to the first subform.
I don't want this to happen. I want existing records not to have the
date altered altered. Other fdetails can be changed (Yes/No on the
"delivered?" field fr example), but not the date.

Does anyone have any ideas??

Regards,
Sam.

[Larry Linson]

Unless you have done something to modify the contents of a control that is
bound to a field in the displayed record, nothing should be saved. I can't
determine from what you've described that you have done anything to change
the value in a control displayed in the subform. If you do so, then perhaps
you need to put a confirmation MsgBox in the BeforeUpdate event of the Form
embedded in that Subform Control.

Larry Linson
Microsoft Access MVP

"Sam Gledhill" <sa***********@hotmail.com> wrote in message
news:a1*************************@posting.google.co m...

Hi, I'm hoping someone can help me out. I have a database with a
form. This form has no recordsource (I'm using it as a complex
MsgBox). It has a single textbox of type Date. It also has three
unrelated subform that are filtered according to the date entered in
the form's text box. By using after update events, I've been able to
allow users to change the date in the textbox and alter records from
the day throughout three other tables.

The problem arises when you close the form. It appears that the form
will alter the first record of the table linked to the first subform.
I don't want this to happen. I want existing records not to have the
date altered altered. Other fdetails can be changed (Yes/No on the
"delivered?" field fr example), but not the date.

Does anyone have any ideas??

Regards,
Sam.

[N. Freemont]

"Sam Gledhill" <sa***********@hotmail.com> wrote in message
news:a1*************************@posting.google.co m...

Hi, I'm hoping someone can help me out. I have a database with a
form. This form has no recordsource (I'm using it as a complex
MsgBox). It has a single textbox of type Date. It also has three
unrelated subform that are filtered according to the date entered in
the form's text box. By using after update events, I've been able to
allow users to change the date in the textbox and alter records from
the day throughout three other tables.

The problem arises when you close the form. It appears that the form
will alter the first record of the table linked to the first subform.
I don't want this to happen. I want existing records not to have the
date altered altered. Other fdetails can be changed (Yes/No on the
"delivered?" field fr example), but not the date.

Does anyone have any ideas??

Regards,
Sam.

Best idea is to visit the MVP site
http://mvp.org
N. Freemont, MVP

[Sam Gledhill]

"N. Freemont" <nf******@hotmail.com> wrote in message news:<24******************************@news.terane ws.com>...

"Sam Gledhill" <sa***********@hotmail.com> wrote in message
news:a1*************************@posting.google.co m...

Hi, I'm hoping someone can help me out. I have a database with a
form. This form has no recordsource (I'm using it as a complex
MsgBox). It has a single textbox of type Date. It also has three
unrelated subform that are filtered according to the date entered in
the form's text box. By using after update events, I've been able to
allow users to change the date in the textbox and alter records from
the day throughout three other tables.

The problem arises when you close the form. It appears that the form
will alter the first record of the table linked to the first subform.
I don't want this to happen. I want existing records not to have the
date altered altered. Other fdetails can be changed (Yes/No on the
"delivered?" field fr example), but not the date.

Thank-you both for you suggestions. On revision, I'm a little
sheepish to say I discovered that at some point I had inadvertantly
bound the textbox control to a table. I deleted this connection an low
and behold the bloody thing works!!

Thanks again,

Sam.