get last record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please Help,

I have a form "frmbilling" with field "duedate"
I have a subform "subfrmbilling"

How can I programmatically create a new record in the subform every (1) one
year based on a date entered in the "billdate" field?

Ex.
"Billdate" = 10/15/2006
when 10/15/2007 comes around a new record will be created

Thanks
 
Create a query with a calculated field, say Next_Bill_Date, using the DMax
*and* the DateAdd functions.
Then create an Append query based on the above query with is filtered to
Next_Bill_Date <=Date()

Again, without knowing the structure of you tables it is impossible to give
you exact syntax

Regards/JK
 

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

Similar Threads

last record 1
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
calculated date field criteria... 7
If field =15 save in two tables 2
Autofill subform when move to new record on Main form 30
Calculated field in a table 6
Use TextBox on the main form to limit SubForm 2
Auto create of new record when accessing subform 3

Back
Top