Increment a value in an unbound form

[cinders]

Hi Everyone,

I will do my best to try and explain what I am trying to accomplish.

I have a form that has two fields [NumbX] and [NumbY]
They way they display on my form is [Numbx] of [NumbY]. These two field show which transaction of the total number of transactions. So basically if someone comes in to do a transaction, they could be doing just one ([NumbX =1] and [NumbY] =1). If they are doing 3 transactions the fields would be [NumbX]=1 and [NumbY]=3. As they complete subsequent transactions [NumbX] increased incrementally, until X =Y.

Every transaction ends with a Print Form opening and the user confirming the printing of the transaction. In the print form I have coded it to clear the main form once X= Y otherwise retain some of the information input in some of the fields for the subsequent transactions. Right now, I have it set up that the user inputs [NumbX] manually. What I would like to do is have that automatically increase by 1 when the print form closes. This should continue until [NumbX]=[NumbY].

The fields are unbound and used solely for driving other activity (opening other forms) so autonumber is not an option.

Any suggestions??

Thanks

 

[MarkK]

Why do you need a NumbY at all?

(pseudocode)
Do
- Enter a transaction
- Hit the OK button
- Increment NumbX
- Print
Loop Until Quit

 

[cinders]

I need Numb Y, because once X = Y the form clears itself out and is ready for the next client's information. Up until that point it retains the client specific information and allows you to enter the different transactions without having to rekey the client info.

I know there are easier ways to do this, but I am replicating an exisiting system for training purposes and this is the way that it functions. It is causing me grief, but I have to mimic it for the purpose of training people and allowing them to practice.

Thanks

 

[WayneRyan]

Cinders,

Forms![YourUnboundForm]![NumbX] = Forms![YourUnboundForm]![NumbX] + 1

Wayne