Automatically update source of an unbound combo-box?

[Guest]

I am new to this database lark - so sorry if my q is daft but please help!

Am using 2000 and I have designed a form to run a query - the results are
then displayed in another form where additional information is to be
submitted.

In the first query form one of the fields is an unbound combo box which sets
a name. Originally I have set the source to be based on a table. My problem
is thinking of the future when a new name is added to the table, it is not
added to my list as it is an unbound control. Is there a way that I can add
some code perhaps that adds a new name thats entered into my properties of
combo box?

Am probably doing this the hard way! Thanks in advance.

 

[Guest]

Hi stephen,

Are you saying the entries in the table you based your combo box on are NOT
being added, or are you saying you are concerned they won't be added?

IF your combo box 'row source type' is set to 'table/query' and you have a
'rowsource' that utilizes a select query based on a table or query, then your
combo box will reflect additions (and deletions) to the underlying table or
query.

That's the whole point of setting up a combo box with a table/query row
source type and a select query rowsource.

CW

 

[Guest]

Obviously it was a daft Q but thanks for your help anyway!

Steph(anie!)

 

[Guest]

No such thing!
CW