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...
 
Back
Top