Drop down box will not populate

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

Guest

I have a drop down box that for some odd reason will not populate, the box is
feed by a SQL script that worked for a while and now will not work.

SELECT [contractors Master Table].EmpNum, [contractors Master Table].nLast &
", " & [contractors Master Table].nFirst AS LastFirst, [contractors Master
Table].ConNum, [Company Master Table].CompanyName
FROM [Company Master Table] INNER JOIN [contractors Master Table] ON
[Company Master Table].ConNum = [contractors Master Table].ConNum
WHERE ([contractors Master Table].ConNum =[Forms]![main menu]![CompanyId])
AND (([contractors Master Table].Active)=Yes)
ORDER BY [contractors Master Table].nLast;

And then when I load the main menu I get an error saying invaild argument,
could this be related to the combobox not populating?
 
Is the Main Menu form open when this is running? If Active is a Boolean
field, try using True instead of Yes.
 
Back
Top