471,075 Members | 1,342 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

Records change in subform!!

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.
Nov 12 '05 #1
3 4037
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.

Nov 12 '05 #2

"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

Nov 12 '05 #3
"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.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.