error - no value given for one or more required parameters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Coll - 29 Jun 2007 15:41 GMT

I'm trying to create a combo box using the wizard. It's based on a
query with 5 fields - enum, ename, startdate, enddate, and
recordnumber. In my query enum is not visible, and that field has
criteria that comes from a text field on a form. The query works fine.
When creating the combo box (using the wizard), I select the fields I
want to add, then click Next and receive the error message.

Any ideas why this is happening? Some of the fields have null values -
could that be causing the problem (if so, what's the work around)?

I even tried making the enum field visible to be sure that wasn't
causing the problem, but it didn't seem to help.

Thanks.

Reply to this Message

Rich P - 29 Jun 2007 17:42 GMT

Hi Coll,

don't use the Wizard for this combobox. Either click on cancel when the
wizard comes up or else click on the Arrow (which unclicks the magic
wand) in the toolbox in the form design view. When your combobox is on
the Form grid, right-click the combobox and go to properties which will
bring up the property sheet for the combobox. You will see that the
Default Row Source Type selected is Table/Query. This is OK. Under
that is the Rowsource. Click on the Rowsource and then on the dropdown
arrow. Select your query. Underneath RowSource is Column count. Here
you can assign how many columns you want to display - where the first
column is the leftmost column of the query.

Rich

Reply to this Message