Rowsource Type Property question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JaneM - 14 May 2008 15:43 GMT

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

Signature

Jane Marlotty

Reply to this Message

John W. Vinson - 14 May 2008 17:53 GMT

>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
[quoted text clipped - 3 lines]
>
>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.

Signature

John W. Vinson [MVP]

Reply to this Message

Maurice - 15 May 2008 08:26 GMT

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

Signature

Maurice Ausum

> 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
[quoted text clipped - 3 lines]
>
> Thanks in advance

Reply to this Message