Refresh data

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi,

I have a main form with a combo-box which displays (and
allows me to select) data from a table. The selected data
is then saved in a field of the table the main form uses.
I also have a command button on the main form which opens
another form and allows me to update the table the combo-
box uses.
My problem is that when I close the window that is opened
by the command button and click on the drop-down of the
combo-box, my new entry is not there.
How do I get the combo-box to refresh and show the added
records?

Thanks
Phil
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

This Q should be in Forms newsgroup. Anyway...

One answer:

In the Close event of the "update form" put this:

Forms!MainForm!ComboBoxName.Requery

Be sure to change all relevant object names.

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBCLWoechKqOuFEgEQIbBwCg25CYJDBR16vLrMkfD5Q+MjYB3sQAn2DL
aOjU6P+dxMlq8IPLQ93ZKA7X
=TvgR
-----END PGP SIGNATURE-----
 
Back
Top