Solved Bound control - Form level event for value change? (1 Viewer)

[GUIDO22]

I have a form with a collection of bound controls. By default, the form loads empty for new record entry but using the navigation buttons can browse historical records.
I have a text control bound to the primary key / ID for this form and if this is NOT NULL ie. an existing record, I wish to run some code...

I thought I could use the Form_Current() event to achieve this, but it seems the current event fires before the controls have populated from the source table...

Thanks in advance

 

[arnelgp]

check this if that is true:
Order of events for database objects (microsoft.com)

 

[GUIDO22]

• Move the focus to another record:
  BeforeUpdate (form)
  
  AfterUpdate (form)
  
  Exit (control2)
  
  LostFocus (control2)
  
  Current (form)
  

  check this if that is true:
  Order of events for database objects (microsoft.com)

  But when I put a breakpoint in the current event and move focus to an existing record- inspecting the bound control value, value is NULL

 

[GUIDO22]

• Move the focus to another record:
  BeforeUpdate (form)
  
  AfterUpdate (form)
  
  Exit (control2)
  
  LostFocus (control2)
  
  Current (form)
  
  But when I put a breakpoint in the current event and move focus to an existing record- inspecting the bound control value, value is NULL

=======================================
Update:
I have moved the call to my routine to the very bottom of the Current event() and it is now working.. cant see why at present.....