Another strange problem . . . Datasheet view trouble - where to look

[buckwheat]

(inherited database).



Form has many cbos. User selected from cbo to view selection; a subform "Provider" opens with no issue. Within that "Provider" subform are several more subforms . . . it's seems all child/parent relationships are in order.

The second subform open fine with more provider data. The third subform source is the qryActive2 that references the forms cbo, e.g., [forms]![Search Options]![grp#]. If I change the format to "single" there doesn't seem to be a problem, I can select each tab and subforms within the tab control. BUT, if left in datasheet, I get a parameter box from qryActive2 that references each field for the form/cbo reference[forms]![Search Options].

Not sure why query runs if in single format but not in datasheet . . . I've checked the query and forms. . . any idea where else I can check?

The only changes I've made to this database is converting over 200 macros to VBA. The macros triggered cmd buttons to open or close forms/report, I did this manually to see what reports/forms were triggered.

[June7]

Not really following that, think would have to work with db and see the behavior.

Did you try Continuous view?

[buckwheat]

can't use continuous form in a subform. I'll keep plugging away to see what I can find. I'll leave unresolved in case someone else has comments or suggestions

[June7]

If it can be Datasheet then it can be Continuous.