Rowsource Type Property question

[JaneM]

I have created a Customer form for our database, but am having a
problem with it. Whenever, I click on it to open the form Error message
"Text may not be a valid setting for the RowSource Type property,
or there was a compile error in the function appears". How do I solve
this problem or how do I determine the cause of the error?

Thanks in advance

 

[John W. Vinson]

I have created a Customer form for our database, but am having a
problem with it. Whenever, I click on it to open the form Error message
"Text may not be a valid setting for the RowSource Type property,
or there was a compile error in the function appears". How do I solve
this problem or how do I determine the cause of the error?

Thanks in advance

Check the Properties of the form - look at the properties of each Combo Box
and Listbox on the form and take a look at the "RowSource Type" property. It
should be either "Value List", "Table/Query" or "Field List" - if it's
anything else you'll get this error.

 

[Maurice]

This could be related to one of the comboboxes having a incorrect rowsource
as source. Maybe a set of Values or Fields instead of a table or query. Check
this first by clearing the different combobox options and then start the
form. By eliminating the steps you'll find the one bugging the form.

In case of the source of the form it could also be that the query has
incorrect syntax. In that case try changing the query to a basic select
statement. If it works you know you might have to adjust your querysettings.

Be sure to test this in a copy of your db and not in the production
environment !

hth