HELP!!! Activescreen control (1 Viewer)

[gar348]

Hello The full code is simple really

Private Sub Order_Value_AfterUpdate()
Forms!FrmNewcastleQRCJobs!PMUEST2![Sell Price] = [Order Value]
End Sub

For some reason changing this is kicking out this error..... but like I said if you navigate to PMUEST2 tab before exit this does not happen...

Structure is Main for - FRMNewcastleQRCJobs
Tab - TabCtl0
Subform within tab - PMUEST2

 

[RuralGuy]

Any chance you could post your db? Remove any sensitive data of course and zip it up before posting. As Doc stated, there is no reason why the code you posted should throw this error. Masking it should not really be the answer.

 

[gar348]

I will need to strip out the data and some of the margin calcs so will upload ASAP

 

[RuralGuy]

Be sure and test what you will upload to make sure it still exhibits the issue, please. Thanks for giving us a chance to get a closer look at this anomaly.

 

[gar348]

No Thank you.....

If you by pass the login screen with shift you need to open test form 1 and double click the list into the jobs...

On the booking page the job value field is the one with the control in....

Guys the database even without tables is to big to upload !!:banghead:

could maybe put it on dropbox??

 

[RuralGuy]

Did you Compact and Repair *before* zipping?

 

[RuralGuy]

BTW, Drop Box is just fine if you want to use it.

 

[gar348]

guys even with most of the tables stripped out its still 5mb !!!

this error is driving me mad - it shouldn't be happening cause its such a simple command !!!

dropbox is blocked at work but I will take a copy of the DB home and share from there later today

any help is appreciated cause ive tried most things (within my capabilities !!):banghead:

 

[RuralGuy]

Did you Compact and Repair *before* zipping?