requery in subform

[putte11]

I have made a Masterform with tabs at the top. (Startf)
One of the tabs show the form PP that is based on the query Hus_ej klart_per_pers2.


The query is based on a dropdown in form PP.
If I fire up PP on its own it works fine but not if I run it through Startf.
Where do I go wrong ?
Patrik

[rpeare]

if your database is in access 2010 can you convert it to something prior and I can take a look.

[putte11]

It doesnt seem to translate to well into prior versions.
Patrik

[June7]

Probably because when the form is opened as a subform need to include the main form and subform control in the reference:

Forms!mainformname!subformcontrol.Form.controlname

Is the subform in Single or Continuous view? Why do you need filter in the subform RecordSource? Synchronizing records with Master/Child Links properties not enough?

[putte11]

Hhmm..
The main form consists only of tabs creatrn in layoutview (2010 style).
Its a task per person form where I can change persons in a dropdown.
June you actually helped me with just about the same issue a few months ago.
By then I made the tabs myself, and that works. But there is somethinge strange with these autocreating tabs that I dont understand.
I cant seem to understand what the mainform name should be. ( I think I´ve tried everything)

[June7]

Are you using a tab control or a navigation form? I don't use navigation form. Review https://www.accessforums.net/forms/t...orm-32053.html

[rpeare]

if your database won't convert, I have to ask. Are you using calculated value or multi value fields in your tables? If so I'd suggest you revisit your design and try to make your structure normalized. Calculated and multi value fields are a big no-no and I don't know why that functionality was added to 2010. If it doesn't hurt the replication of your error you can likely create a copy of your database, delete those fields that are calculated or mutli valued and convert it.

[putte11]

Solved this one !
I used navigation a form. A bit strange but the container for ALL tabs was called NavigationSubform. I was looking for a specific container for each tab.
Correct filter syntax in my query was
[forms]![Startf].[NavigationSubform].[form].[VEM3]
VEM3 being my combobox.
Thanks everybody for the hints.