Combo Box on form not dumping info into table

[Karin]

New user - need help

I have several tables. SPA INPUT, VENDORID, DEPTID, etc..

I have created a form to enter data into the SPA INPUT table. One of the
fields is VendorID. I created a Combo Box to limit VendorID entries to only
those listed in the VendorID table (to prevents typos and/or a new vendor
from sneaking by proper channels). If I use the VendorID column in the SPA
INPUT table for the combo box I get many duplicates (because the SPAInput
table has a different primary key) and the drop down list defeats the purpose
of quick entry. What I have created so far either rejects my choice for the
VendorID field stating "the field <name> cannot contain a null value because
the Required property for this field is set to true. Enter a value in this
field (error 3314). or...... during many of my attempts at fixing this
problem....my form is processed and data dumped into the SPA input table
leaving this one VendorID field BLANK.

I think I have not bound this field correctly? definitely don't understand
why it treats my combo box choice as "null" when I have in fact chosen it.

Please help if you can.....thanks very much. Karin

 

[Doogle]

Hi from the UK, Karin

The row source for a combo box doesn't have to be from the same table or
query that the form itself is bound to. So I suggest you make the 'row
source' for the VendorID the main Vendor table itself. (And, assuming your
combo has, say, Vendor Name in column 1 & VendorID in column 2, be sure that
in the combo's Format Properties thast the column count is set to 2, and that
in its Data Properties the bound column is also set to 2.

Hope this helps - please let me know.

All the best

 

[Karin]

Hello yourself Thanks so much - form is up and running!!! Enjoy your
weekend!

Karin

 

[Doogle]

Karin,

I'm glad my reply helped you - only my second day in the newsgroups! I could
get hooked on this....

Take care & you, too, have a good weekend. Hopefully you're further from the
London bombs that we are (about 10 miles....)

All the best!