Refresh data in a combo box
- From: "KittyS" <kcskrobela@xxxxxxxxx>
- Date: 8 Dec 2005 12:11:22 -0800
I have a form that shows info for a single table. One of the controls
is a combo box that lists all the existing values in that field in that
table, using this SQL:
SELECT [Ads small version].Publication
FROM [Ads small version]
GROUP BY [Ads small version].Publication
ORDER BY [Ads small version].Publication;
Limit To List is set to No - the users have to be able to enter new
values, it's just for their convenience that I show what's been used
before.
The list is fine when the form is first used. When a new value is
entered, it is saved in the record. But when I go to another record,
the new value I just entered doesn't show in the list.
I'm sure it's really easy to refresh the list, but I can't figure out
how. Help?
TIA
Kitty, Newbie
.
- Follow-Ups:
- Re: Refresh data in a combo box
- From: Ken Snell \(MVP\)
- Re: Refresh data in a combo box
- Prev by Date: Re: Using AxDate Control
- Next by Date: Re: viewing records in a form
- Previous by thread: Re: sequential numbering
- Next by thread: Re: Refresh data in a combo box
- Index(es):
Relevant Pages
|
