Cascading NOT cascading

[MarinaJ]

I have tried to research this on my own, and I'm now turning to the pros.

My setup:
Combobox 1 = boxtype
Combobox 2 = boxcrop
Form = Forages
Table1 = Type of Crop
Table2 = Cropnames

I have two cascading boxes which when I select my first, it gives the error:
"Enter Parameter Value - Forms!Forages!boxtype"
If I click through this I get -
User-defined type not defined (It is refering to the After Update expression).

My 1st combo box has my [Type-of-Crop] table as its row source and table/Query as Row Source Type.
After Update has [event procedure] Me![boxcrop].Requery

I have also checked my criteria on my query which is my rowSource on my second combobox:
Query:
Crop -
CropTypeID and criteria under the cropTypeID is - [Forms]![Forage]![boxtype].

Is this obvious to anyone?

Thanks in advance.
Marina

 

[MarionD]

Hi Martina,

Is the form called Forage or Forages? Or is this just a typing error?


"Enter Parameter Value - Forms!Forages!boxtype"

CropTypeID and criteria under the cropTypeID is - [Forms]![Forage]![boxtype].

Marion

 

[MarinaJ]

Cascading NOT

Sorry, it is Forages in both instances.

 

[MarionD]

Hi Marina,

I assume you are trying to enter Data into a third Table?

I have a small Example of what you need. If you are using Access 2000 I could mail it to you if you like.

Marion

 

[Pat Hartman]

If boxtype is actually on a subform, the reference is incorrect. It would be:

Forms!mainformname!subformname.Form!controlname

 

[MarinaJ]

cascading

"boxtype" is a combo box and "boxcrop" is a list box, they are both controls on my form [Forages]

Once I click through my error messages, I can select from my boxtype to select my types of crops. If I do, I get an error message "User-defined type not defined" (It is refering to the After Update expression).

My list box should give me my list of crops according to the type I have selected. Thanks.

MarionD,

I am not trying to enter this information in another table. For now this is the first part to a series of selection for the user. I have a thread called "Database Design Question" which explains in detail what I hope to accomplish.

Many thanks,
Marina