File Management

[Lindsur]

I've created a very simple file management database, but I'm having problems. I'm a beginner user of access, so this is probably relatively easy to do. I'm not familiar enough with coding to do this without help. I need for the data base to auto update a field when a corresponding field is populated. I have a client name field, and a client number field. If someone were to type in the client number, I’d like the client name to populate. Vice versa would be good as well. I’d also like to set up a splash screen that can take users to either a search form for users just searching for individual files (should be simple, but again I’m a newbie) and an input form for me to use.

Can anyone help walk me though this process?

[pbaldy]

If I'm understanding correctly, I use two combo boxes, both bound to the number. One displays numbers, the other names.

Private Sub cboAcctName_AfterUpdate()
  Me.cboAcctNum = Me.cboAcctName
End Sub

Private Sub cboAcctNum_AfterUpdate()
  Me.cboAcctName = Me.cboAcctNum
End Sub