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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used lookupwizard for a field to list some items. When I created it I
selected that I would type in what was needed as these items are not in a
table. Typed in the items and saved etc.

Placed this field on my form, all ok so far.

I have a supplier form and when I click on a command button it opens a stock
form and opens it with the suppliers no. in that form in a field.

Now the field within the form for the items is displayed also, but this
contains in it when the form opens a -1 and if I then look at the list it
contains the items I typed in.

Why does it show -1, this is causing the form to not work as I want it
too... please can someone help me asap... pleeeeease!

thanks
 
Consider:
-don't use lookup fields in table designs
-use combo boxes based on tables on your forms
Redesign your tables and forms and queries to not use lookup fields and do
use related tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List Box shows -1 in the field on the form when it opens 6
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
List Box shows -1 in the field on the form when it opens 1
List subform items on main form 2
looping thru a continous form 5
If statement at open of Form? 1
Need combo box to refresh when moving to new record 2017 1
showing a subform based on the main form 5

Back
Top