Combo works in Form view but not in Datasheet view?

[Bob Vickers]

I have a Product ComboBox dependent on the contents of a ProductCatagory ComboBox. (only Products in the Specified Catagory are shown). This works in Form view - i.e. only showing a single line of the order at a time, but does not work in Datasheet view. In Datasheet view the right Products come up and I can select one but as soon as I click off it disappears.

I need the form in datasheet view in order items by line. I have the following Requery at form level what is missing/wrong.

Private Sub Form_Current()
Me.Product.Requery
End Sub

 

[dnesci]

In datasheet view, you can't use a combobox. Set your form view to continuous and you should get all the records your expecting.

 

[Bob Vickers]

Hi dnesci

The form set in continuous view works as badly as in dataview. I have read that whilst in both these views it looks like there are seperate records Access somehow treats them as one. Is this correct?

 

[JANR]

It's a known problem with cascading combos on a continuous/datasheet form, there are some hacks out there like this :http://www.databasedevelopment.co.uk/examples.htm

Download the "Continuous Form Combo" example and try it out.

JR

 

[Bob Vickers]

Thanks for the input. I'll be studying how they managed it. I would love to crack this. A a brief glance I cannot see anything and do not understand what is meant by the Aligned and Behind buttons.

Cheers