Value List vs. Table

[JamesJ]

Any advantages to using a value list or a table to populate a combo box?

I have a combo box on a form populated with a value list with 9 items. In
the AfterUpdate of the cbo I'm using Select Case to run code pending the
selection made in the cbo.

At this time I have no intentions of changing, adding or removing any of
these
items. Is there something I'm missing that would make using a table for
these
values more advantageous?

Thanks ahead of time,
James

 

[Rick Brandt]

Any advantages to using a value list or a table to populate a combo box?

I have a combo box on a form populated with a value list with 9 items. In
the AfterUpdate of the cbo I'm using Select Case to run code pending the
selection made in the cbo.

At this time I have no intentions of changing, adding or removing any of
these
items. Is there something I'm missing that would make using a table for
these
values more advantageous?

Only later when you decide to change, add, or delete any of the items.

--
*******************************
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
*******************************

 

[JamesJ]

Yeah, I think your right.

Only later when you decide to change, add, or delete any of the items.

--
*******************************
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
*******************************

 

[JamesJ]

I went ahead and created a table with and ID field and the item field.
When I implemented it I began to get an error message on a line in the
OnOpen of the form which I set the MonthView control on the form:
Me!acxMainCal.Value = Date
I guess I should have written the error down.
Never had a problem with this before. I thought maybe the Monthview became
corrupt so I deleted it and replaced it with the same results.
So I went back into the table and removed the ID filed and left only the
Item field
and now everything seems to work fine. I just can't figure out why or how
this
would effect the MonthView control?!

James