Combo box contents not updating

S

Stapes

Hi
I have one form open which uses a combo box to display an Items name
where the record holds just its key. I am opening another form and
adding new items. I requery the first screen afterwards, but on return
to the first screen, the new items name is not displayed. I assume the
combo box does not update itself with the new contents. Can I just
requery the combo box source?

Stapes
 
F

Franck

for example you have form1 which have the item and form2 wich have a
label let say that received value of : form1!cboItemName.value
so the label retreive the value of the combobox of form1 so if form1
close what his value equal to .... the answer is nothing so empty the
value of the label. If you really have to close the previous form i
suggest 1 easy way, on the button to load the form2 go edit the code
and add code after the docmd.openform ....
to give value of the form label the one of the current combobox. like:
docmd.openform form2
form2.lblLabelItem = form1.cboItem
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top