A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

update combo box with each entry



 
 
Thread Tools Display Modes
  #1  
Old May 21st, 2004, 12:01 AM
JRLH
external usenet poster
 
Posts: n/a
Default update combo box with each entry

I am trying to set a combo box so that it updates as I add
each new record. For example, the current box I'm working
on involves a list of potentially all of the hospitals in
the state, and each time I have a patient record from a
new hospital, I would like the combo box to be updated so
the name of the new hospital can be selected from the
combo box list later on.

Jennifer
  #2  
Old May 21st, 2004, 12:49 AM
Ted Allen
external usenet poster
 
Posts: n/a
Default update combo box with each entry

Hi Jennifer,

To do this, use a query as the Row Source for the combo
box. Just set up the query to query the unique list of
hospitals from your database. That way, every time one
is added it will automatically show up in the list in the
future.

HTH

-Ted Allen
-----Original Message-----
I am trying to set a combo box so that it updates as I

add
each new record. For example, the current box I'm

working
on involves a list of potentially all of the hospitals

in
the state, and each time I have a patient record from a
new hospital, I would like the combo box to be updated

so
the name of the new hospital can be selected from the
combo box list later on.

Jennifer
.

  #3  
Old May 21st, 2004, 04:45 PM
external usenet poster
 
Posts: n/a
Default update combo box with each entry

I was able to get it to work, but the combo box is
allowing duplicates from the pull-down menu. For example:

Cook County Hospital
Cook County Hospital
Mayo Clinic
Mayo Clinic

The table that the query is based on is indexed to prevent
duplicates. Any suggestions?

-----Original Message-----
Hi Jennifer,

To do this, use a query as the Row Source for the combo
box. Just set up the query to query the unique list of
hospitals from your database. That way, every time one
is added it will automatically show up in the list in the
future.

HTH

-Ted Allen
-----Original Message-----
I am trying to set a combo box so that it updates as I

add
each new record. For example, the current box I'm

working
on involves a list of potentially all of the hospitals

in
the state, and each time I have a patient record from a
new hospital, I would like the combo box to be updated

so
the name of the new hospital can be selected from the
combo box list later on.

Jennifer
.

.

  #4  
Old May 24th, 2004, 03:29 PM
Ted Allen
external usenet poster
 
Posts: n/a
Default update combo box with each entry

Hi Jennifer,

You can prevent duplicates from being listed by changing
the query "Unique Values" property to yes.

HTH, Ted Allen
-----Original Message-----
I was able to get it to work, but the combo box is
allowing duplicates from the pull-down menu. For

example:

Cook County Hospital
Cook County Hospital
Mayo Clinic
Mayo Clinic

The table that the query is based on is indexed to

prevent
duplicates. Any suggestions?

-----Original Message-----
Hi Jennifer,

To do this, use a query as the Row Source for the combo
box. Just set up the query to query the unique list of
hospitals from your database. That way, every time one
is added it will automatically show up in the list in

the
future.

HTH

-Ted Allen
-----Original Message-----
I am trying to set a combo box so that it updates as I

add
each new record. For example, the current box I'm

working
on involves a list of potentially all of the hospitals

in
the state, and each time I have a patient record from

a
new hospital, I would like the combo box to be updated

so
the name of the new hospital can be selected from the
combo box list later on.

Jennifer
.

.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:42 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.