Search results for query: *

Thanks M and Bill for your replies. M, i will post the code at the bottom. I finally got it sorted out and once again it was a reasonably simple thing but sometimes they seem to be the hardest to see. Bill, i was using the Master/Child fields with the form that had the subform, but the Delivery...

My problem is a subform is updating one record behind what it should be. It concerns 2 forms/tables i am dealing with . The 1st form/table is for grain delivery records.2nd form/table is for grain sales.On the grain delivery form i have a button that opens the grain sales form to a new record...

Thanks again. That is handy to know. I did change the 'after update' to a manual text box and it seems to be working fine now. I know i am being a bit painfull but there now happens to be another thing i dont know why is happening. It concerns the 2 forms/tables i am dealing with but different...

Thank you both. So simple. I must have tried everything but the simplest. Another little issue if you happen to look back here. The text box i am setting the variable from is actually an autonumber. When i am on a new record does the after update, on the autonumber text box, kick in straight...

I have declared a public variable in the Public declarations modules section and am setting its value to a field on a form in its 'after update' and 'on current' properties of the form(both are needed for different situations). When i come to use it to set another field on another form (not...

I want to check if the current record on a form is a new record or not and then take appropriate action. At the moment in the 'On current' event property i allocate the value of a text box to variable,which i use on another form. This works fine until i go to a new record and there is nothing in...