Which event to use update/append?

[Guest]

I have a form bound to a table each record based on a [Registerdate].

An unbound text box [RegisterDate] on the form with form calendar to insert
date into this text box.

Once the date is inserted into the text box, I want to move this date
creating a new record in the table the form is based upon.

Which event on the text box can I use to trigger a DoCmd.RunSQL statement
that will append this date to my table creating a new record?

Better yet, can I have a combo box listing the [RegisterDates] from this
table so I can choose which record to pull up and if so, I would like to have
the ability to add a new [RegisterDate]/record in the manner described above?

Thanks for your ideas and help

 

[Alex Dybenko]

Hi,
if you enter date in calendar form - then you have to use it event; you can
make a public method in main form class module, say UpdateRegisterDate, and
then call it from your calendar form after user select date:

Forms("MainForm").UpdateRegisterDate datSelected

where datSelected is date selected in calendar

in UpdateRegisterDate you can set RegisterDate to datSelected and then run
DoCmd.RunSQL statement

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Thank you for the suggestion, thinking this was a dead post without answers I
worked on a different approach and came up with a new problem which I just
posted under "Form Refresh Problem".

Hi,
if you enter date in calendar form - then you have to use it event; you can
make a public method in main form class module, say UpdateRegisterDate, and
then call it from your calendar form after user select date:

Forms("MainForm").UpdateRegisterDate datSelected

where datSelected is date selected in calendar

in UpdateRegisterDate you can set RegisterDate to datSelected and then run
DoCmd.RunSQL statement

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

I have a form bound to a table each record based on a [Registerdate].

An unbound text box [RegisterDate] on the form with form calendar to
insert
date into this text box.

Once the date is inserted into the text box, I want to move this date
creating a new record in the table the form is based upon.

Which event on the text box can I use to trigger a DoCmd.RunSQL statement
that will append this date to my table creating a new record?

Better yet, can I have a combo box listing the [RegisterDates] from this
table so I can choose which record to pull up and if so, I would like to
have
the ability to add a new [RegisterDate]/record in the manner described
above?

Thanks for your ideas and help