By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,183 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Updating listbox.

P: n/a
I have a list box that is populated by an SQL statement. On that form,
I have a button that opens another form that the user adds data to the
table that the SQL statement uses to populate the listbox.

I would like to be able to have the list box updated to show that new
information after I close the new dialog box. It does, only when I
close that Form Dialog box and open it up.

Thanks for your help. Here is an overview:

1. I have a Form with a list box.
2. That Form has a button that opens another form.
3. When I close that other form, I want the data added to show up in
the list box.
4. The list box is popluated by an SQL statement.

Thank you.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Karen Hill wrote:
I have a list box that is populated by an SQL statement. On that
form, I have a button that opens another form that the user adds data
to the table that the SQL statement uses to populate the listbox.

I would like to be able to have the list box updated to show that new
information after I close the new dialog box. It does, only when I
close that Form Dialog box and open it up.

Thanks for your help. Here is an overview:

1. I have a Form with a list box.
2. That Form has a button that opens another form.
3. When I close that other form, I want the data added to show up in
the list box.
4. The list box is popluated by an SQL statement.

Thank you.


After the line of code that opens the dialog form (assuming that you are
using the acDialog argument) add...

Me.ListBoxName.Requery
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.