Append query and combo box on the form

[SylvieB]

Hello group

I created an append query and all records were copied into an existing
table. Everything went fine. On the form, however, some information does not
show. I noticed that if it’s a combo box, the data does not show. If I change
it on the form into a text box, the field gets populated. What can I do for
the data from the append query to show on the form and keep the field as a
combo box? The display control on the table is combo box. That’s why I don’t
understand why the data is not showing on the form. Any idea why? Thank you

 

[John W. Vinson]

Hello group

I created an append query and all records were copied into an existing
table. Everything went fine. On the form, however, some information does not
show. I noticed that if it’s a combo box, the data does not show. If I change
it on the form into a text box, the field gets populated. What can I do for
the data from the append query to show on the form and keep the field as a
combo box? The display control on the table is combo box. That’s why I don’t
understand why the data is not showing on the form. Any idea why? Thank you

You may need to Requery the combo box after running the query. If you close
and open the form does the data show up? If not, what is the combo's Row
Source?