Re: List Box shows -1 in the field on the form when it opens

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Saj

You just answered your own question. You said that the first name in the
stock table is "-1". If your combo box uses that field as its ControlSource
then that is what you will see regardless of what is in the combo list.

A bound combo box does 2 things. It shows what is in the field it is bound
to, and it provides a list to choose from to replace or fill that field.
--
Bill Mosca


"Saj" wrote:

Hi again

Bill - the only field that contains a -1 is the first field in the stock
table for the first stockname, so when I go to the combo box that looks at
all the stock items and lists them, it shows -1 for that field.

Bob - I have a stock table that contains stockNo, stockname
The stockNo is a autoNo and the primary key, the stock name is the combo box
that is a value list that I typed and contains:
Accessories
Clothing - Ballet
etc

The stock name field is Text type. When I look in this table the firt item
instead of shoes (which is what was chosen from the drop down list and is the
last item in the list) it shows -1.

I can not change the stockno to a text value as it has relationships with
other fields in other tables.

But it is not the stockno that is the problem, it is the stockname, why does
it keep changing the first stockname in the Stock table to a -1?

Still no clearer on this, any other suggestions as not got much hair left on
my head from all the pulling I have been doing...

Thanks

"Bob Miller" wrote:


Look at the Control source of the combobox and then determine the data
type of that field in the underlying table. Make sure it is Text.
Saj Wrote:
Hi to Bill & Bob

I re-looked at this field and it is a combo box that was created to
lookup
items:

required - yes
allow zero - no
indexed no - no
display - combo box
row Source - Value List
Bound Column - 1
Column count - 1
Column head - no
limit to list - yes

The row source shows the items as I typed in the list when created
with
wizard first items:
"Accessories";"Clothing - Italian";"Clothing - Ballet";"Shoes" and so
on

So not sure where the -1 comes from?

If you have any ideas please help... thanks again




--
Bob Miller

.

Relevant Pages

  • Re: These Hypocrisies are NOT the Christians problem
    ... Roll Call's annual list of the 50 richest Members of Congress hasn't changed ... owing to the drop in price of her stock in RealNetworks, ... one point her net worth was estimated at about $40 million, ... He also lists interests in a Denver mobile home community; ...
    (alt.sports.football.pro.ne-patriots)
  • large, spurious[?] TSC skews on AMD 760MPX boards
    ... deluge of user support on my own lists;-] ... quite right' when running at stock speed. ... I discovered that overclocking by about 10% made the problem ... it was always the only way to make the problem disappear and I ...
    (Linux-Kernel)
  • Re: How to capture another proccesss TStringGrids content??
    ... That program must be getting its data from somewhere, unless that program *is* the stock market for this local area. ... TStringGrid doesn't populate the buffer with all the strings it knows about. ... You can use ReadProcessMemory to read whatever memory you want, but then you need to figure out which memory you want. ... It keeps a sparse list of sparse lists of strings, and moving things around visually doesn't move them around in memory. ...
    (alt.comp.lang.borland-delphi)
  • Re: Before you die lists
    ... Haven't since cared to pick up a book just because cover said author is a nobel laureate - though I've read several & liked too, it's never because of nobel stamp. ... But if I have to put something from that era - at least for non-western audiences, I would go for Apology; at least it was fun to read, & demystified Socrates. ... And any book so thick should probably be disqualified from all time lists:) ... Even the urchins that can afford to stock may be just a dozen books every morning & must clear the entire stock by afternoon selling them a signal tend to stock it - it moves that fast. ...
    (rec.arts.sf.written)
  • Re: Help! Confused!
    ... If user chooses an entry from one combo box, ... Can user change the stock name for a given stock number? ... "Brook" wrote in message ... >>> ComboBox StockName. ...
    (microsoft.public.access.forms)