Recent content by gearcam

i have the mesg box running and a stop line in the start of the error check. Its not the code that is wrong the main form sometimes does not appear to run the "Current" section sometimes from a search or somthing not sure what yet

it does not error out it sometimes just does net set the field as it should but i can not seem to trace exactley the rout of the problem It runs on a sub form, the main form has serch functions reset etc etc etc so i have to figure out exactley the events that make it miss this routine !!

hi thanks for your help it works pretty good but not all the time i can not see why

thanks that seems to work in the test ill try it tommorow for real I am trying to understand how it works how does blIsLoaded get its data ? Ok i get it the first time througn it must be Null then its set

i mean the record just looked at In this case For example, I could be on record 10 and jump to record 20. Is my previous record record 10 or is it record 19 or 9? the record i want to amend is no 10

Ok see attached test database

not so easy as it is huge with lots of forms and tables but i will copy the relevent bits to a new database

ok ill will buld a new test database from scratch and see what happens thanks Steve

Ok here is the full set up The base table for all the data is called orders I have a query with all fields called ordersfull (this is the new part) I have a form called orders which is linked to the query ordersfull this is the current section of the orders code Private Sub Form_Current() On...

Ok i have changed the data source for a new query that is linked to the table but i still get error 3021

no chaning to a query is a bit more complicated i think thi form has many many uses not sure if they will all work ill give it a go

That must be the problem then my form is linked to a table It works if i change to .movefirst so can i get the number of the record currentley showing on the screen and use that somehow ?

thanks i am going to giove this a try So i add this into the form current code ? I always get error 3021 "no record"

probablly i have quiete a good understanding of VB in access Can you show me what you mean ?

yes just amend a field content So on opening the record the "current" sets a field to a value Then on leving it sets to another value. This will then be used to se if the form is open elswhere on a shared database