Adding a new Record to a Subform - Programmatically!

S

sol.shapiro

Hello ALL!

I have a subform (which is not bound to the main form though it has a
SQL statement as its' Recordsource).

I would like to add a new record (based on a code snippet that I wrote
that determines the previous "business" day - allowing for Holidays,
Sundays etc.,).

My first record in the subform is the date of the query - based on the
Textbox entry in the Main form. I would like to be able to, upon
changing the information in the Main (I guess on the AfterUpdate Event
of the TextBox) form to add the predermined date about the date.

I can add the record manually, but I would like to have it set
programmatically, for the users not to fiddle with the inofrmation.

I am not quite sure how to get the code to insert (AddNew) to that
Recordset.

Comments?

Sol.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top