Problem updating fields based on cbo box

[Shawn29316]

I'm trying to build a simple application with 2 forms. First form allows person to choose their name from a cbo box and their employee number will be populated automatically from the same table. They'll click a button and the second form will open with results from a second table, based on the employee number. It all works except, if the employee clicks on the wrong name on the first form and then selects the right one, the employee number doesn't change. This has driven me crazy for hours! Can someone please bail me out?

[jforbes]

What does your code look like?

[Shawn29316]

Mr Forbes,

I appreciate your interest in helping me! I decided to go a different direction that I could make work so I'm okay for now.

I've been given an assignment that's over my head so please don't be surprised if you see more questions in the next few weeks.

Thanks,
Shawn