Hi All

I am designing a till system and have two types of till.

Each time a cashier logs onto a till they start a 'session' which records the till they are using, the cashier details and a start and finish time.

I need two types of till screen (forms) for the two types of sales.

Wash sale: The main form is a session form with each transaction within that 'till session' being a subform (transactions). This form works perfectly, does all that is required and print the receipt using 'print' and the where command to filter to the correct transaction number.

Shop Sale. This form is more complicated. One 'session' has many transaction and one transactions has many 'items in transactions'

The main screen is a 'till session' form, the 'Transaction' subform linked to the amin form is another form with a further sunform embedded into it (items in transaction subform).

It all works except a problem printing the receipt which keeps comming up blank. I have worked out that when the macro opens the 'print receipt' report that the 'transaction' record has not made it to the transaction table which the report is sourced from!

I understand that when a form is open the details entered are not saved into the table until the record has been closed/ you move to another record/ or go to a new record.

To solve this before the receipt is printed the macro uses the 'goto record, next' which should save the original transaction record in the table thus allowing the report to find it.

On the wash till (one form, one subform) this works great and the receipt prints as required but on the shop till (one form with one subform containing another subform) it does not work. Both types have a mirror image of macros controlling them so what works for one should in theory work for the other?

Anybody have any idea why the form with the subform that contains a subform doesn't seem to save the details when the ist subform goes to a new record.

I am convinced this is the source of the problem

Thanks in advance

Chris, London