Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Subform behind in updating
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...- Jonmit
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Public variable losing value?
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...- Jonmit
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
check if new record on form
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...- Jonmit
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
