Help Please

[marklane2001]

Hi,

Sorry I am pretty new to all of this so I have another question which is stumping me still.

I have attached the DB for you to have a look as it will be a lot quicker I guess. No laughing please as like I said I am new to this

The first form open is FRM_MAIN
You then select the top option of OPupil Details which opens FRM_PUPIL filtered by pupil ID
You then select an invoice line in the first list box (double click or click once and then press the button)
This then loads FRM_CLASS_PAYMENT2

I then add a payment amoutn and type and then press the Enter Payment button

I then get the following error and can't work out why or how to resolve it...any ideas

"Run Time Error 3211

The database engine could not lock the table
TBL_CLASSES_PAYMENTS_PUPIL_LISTBOX' because it is already in use by another person or process"

 

[donbettis]

If you remove "TBL_CLASSES_PAYMENTS_PUPIL_LISTBOX" fom the row source on FRM_CLASS_PAYMENT2 - this should fix the problem.

 

[marklane2001]

Thanks a lot for your reply. This worked. Not even sure why it was on there!

On the same note would you be able to tell me how to update the lstCLASS_INVOICE list box with the payment amount showing as requery doesn't seem to work on Open form as I get an error (it asks for the PUPIL ID) . It might just be my append queries though