View Single Post
  #3  
Old June 19th, 2004, 07:39 PM
Tim
external usenet poster
 
Posts: n/a
Default "Invalid argument" error message when trying to use a combo box


-----Original Message-----
Sounds to me as if the query that is the Row Source for

the combo box has an
error when trying to use a function that is one of the

query's fields.
Often, this can be because a Null value is the value of a

field that is an
argument for a function that is being called.

You will need to check the query to see which functions

it may be using, and
then check your data.

-- I'm not new to Access, but basically self taught and

not very knowlegable, so I'm not sure that I understand
your possible solution to the problem that I'm having. I
don't understand why the combo box works fine on a Windows
2000 computer but not on a Windows XP computer. Could the
problem be related to XP and not to the Row Source query?


Ken Snell
MS ACCESS MVP

"Tim" wrote in

message
...
I have an Access 2000 backend database on a Windows 2000
Small Business server. Front end is an MDE database. I
have a subform with a combo box that works fine on the
front end when working on the server, however when

working
in the front end on a Windows XP computer the combo box
gives me the "invalid argument" error and there are no
options in the drop down box to select from. I have

other
combo boxes on the same subform that work fine. Any
thoughts? Thanks.



.