Auto Update

[Damien]

I cant find a way that will let me autoupdate my table.
I want to be able to enter Acct. Codes and once i have
entered them in the form the table will just add them to
my drop down list.

 

[Private Sub Form_AfterUpdate]

The dropdown list is static after the form is loaded but
you can tell it to requery once the form detects a new
record or better yet when anything is changed to capture
renamed values.

Private Sub Form_AfterUpdate()
cboWhateverName.Requery
End Sub

-Cameron Sutherland