Automatically moving data from 1 form to another after a certain amount of days

[Martymcfly]

Im having some trouble trying to do this. Can somebody please help me..?

I have 3 forms:
FORM A, FORM B, FORM C.

FORM A lets me put data into a couple of text boxes ("Invoice No." & "Days waiting")

I want to have a "SUBMIT" button which sends the data from FORM A into a list format in FORM B.

FORM A is now clear a free to use for the next submission.

The data in FORM B sits on the list until the number of "Days Waiting" - from FORM A is up. Then it automatically moves from FORM B to FORM C.

Then, when you submit a second submission , this also is sent to FORM B and sits underneith the first one?

Im sure this is relativly easy, but fot the life of me, I cant do it and its driving me nuts!

Please, Somebody, HELP ME!!

Thanks

:o)

[NeoPa]

It's very unusual, but not impossible in a very restricted way, to store data in forms rather than in tables underlying the forms.

Your question indicates that you may actually be trying to do the former. Is that true? If so, and you can explain why you feel this is appropriate, then I may be able to help (Only after you've provided the information the question needs though, like what the forms are called; the names and types of the relevant objects; whether any of the objects are bound to underlying data; etc).

Please be careful to answer all questions in any response. So many members answer just one or some and expect us to proceed from there (which isn't practical).

[TheSmileyCoder]

There are several ways to do such a thing. An example could be:

In your table include the 2 fields:
b_Submitted, Numeric Long, Default=0
dt_Submited, Date/Time, No Default

• Form A
  Set the underlying query to have a where clause including only those fields where b_Submitted=0 (or False)
  When pressing your submit button in Form A do the following events:
  Set b_Submitted=True
  Set dt_Submitted=Date()
  Requery Form A.
• Form B
  Set the underlying Query to only include those fullfilling;
  b_Submitted=True
  Date()<DateAdd("d";[Days waiting];dt_Submitted)
• Form C
  Set the underlying query to only include those records fullfilling:
  b_Submitted=True
  Date()>=DateAdd("d";[Days waiting];dt_Submitted)
  
  I think this should fullfill your listed criteria.