Not in List

  • Thread starter Thread starter ThomP
  • Start date Start date
T

ThomP

I have a Not In List Code. When I add a new entry to the list I get an error
message saying "Too Few Parameters Expected 1."
This List in based on a Table called OrganSite. This is my Row Source for
the Combo Box:
SELECT DISTINCT OrganSite.[Cancer ID], OrganSite.Cancer FROM OrganSite ORDER
BY OrganSite.Cancer;

Here's hoping.
 
ThomP said:
I have a Not In List Code. When I add a new entry to the list I get an error
message saying "Too Few Parameters Expected 1."
This List in based on a Table called OrganSite. This is my Row Source for
the Combo Box:
SELECT DISTINCT OrganSite.[Cancer ID], OrganSite.Cancer FROM OrganSite ORDER
BY OrganSite.Cancer;
Click to expand...


It sounds like you misspelled a field name in the Insert
Into query.
 
Thanks for the help
--
thomp


Marshall Barton said:
ThomP said:
I have a Not In List Code. When I add a new entry to the list I get an error
message saying "Too Few Parameters Expected 1."
This List in based on a Table called OrganSite. This is my Row Source for
the Combo Box:
SELECT DISTINCT OrganSite.[Cancer ID], OrganSite.Cancer FROM OrganSite ORDER
BY OrganSite.Cancer;
Click to expand...


It sounds like you misspelled a field name in the Insert
Into query.
Click to expand...
 

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

Formatting combo box drop-down list 1
On Not In List 1
Can't select from list box 3
Auto reduce the items in list in Combo Box 1
Need 'entered' value added to list 8
Cascading Combo Boxes 2
Limiting combo box selection 1
Cascading Combos Again 1

Back
Top