Dependent Combobox in a Datasheet in Access?

Question

I've created a dependent combobox as mentioned as this article. http://office.microsoft.com/en-au/access-help/basing-one-combo-box-on-another-HA001173058.aspx

However, the problem I'm having is that I'm trying to do this with a datasheet. When I specify the criteria as another field, it'll look at the first row's value instead of the current row's value. I'm willing to do this as a contiguous form as well, but don't know if that would help.

Could you clarify a little please, are you using combo boxes on a form and the showing the datasheet as part of a subform. Also what do you mean by specifying the criteria as another field? Are you using a bound or unbound form? — Matt Donnan

Fionnuala Fionnuala · Accepted Answer · 2012-01-04T19:49:29

Unbound controls in a continuous form will only drive you insane. Consider modifying the underlying query to ensure that your combo is based on a bound column (field).

Dependent Combobox in a Datasheet in Access?

1 Answers