While adding a new record the name does not show from a combo list

  • Thread starter Thread starter newataccess
  • Start date Start date
N

newataccess

I created a combobox of ID, NAME. When I go to the form and lookup existing
records, the name shows up. But when I am adding a new record, the ID, Name
shows up in the combo box, then I tab out and it stores the ID to ID2 but it
would not show the name on the name field on the form.

But when I go out of the form and come back in, the name is showing up.
What am I missing?

Thanks.
 
I am not sure that I understand exactly what you are having the problem with.
Are you modifying the Combobox Row Source or modifying the Combo's Control
source?

Me.Recalc 'Immediately updates all calculated controls on a form.
Me.Requery 'Updates data in a recordset by re-executing the associated
query.
Me.Repaint 'Completes any pending screen updates on a form as well as
any pending recalculations.

You can use the above in Code Events. Which event can be dependent on
exactly what you require.

If the above doesn't answer your question then perhaps you can provide a
little more explanation of your problem.
 
Back
Top