Phil
I'm not quite sure about your setup. Did you link the master and child fields of the sub form to the main form? If the sub is already linked I truly can't picture what is going on. Can you upload a sample zipped file for us to play with? If you can, please put it in the Files>Assistance Needed folder.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "pdk444444" <pdk444444@...> wrote:
>
> I have a Category table and a Sub-cat table which are maintained by a form/subform arrangement.
>
> Each Category may have 1 or more sub-cats (or none at all)
>
> I have another table which contains fields for Category and Sub-cat each of which are selected from a drop down list. They are selected seperately but I want the sub-cats list to only contain the subcats that are valid for the entered category.
>
> I achieve this by having a query to select the sub-cats with criteria [Forms]![Formname].[cat id].
>
> In form view everything is fine.
>
> I have 2 issues.
>
> 1. When the form is viewed in datasheet view (which it mostly is) I only see the values for sub cat for those records with matching categories. The records with other categories show as a blank field in sub-cat.
>
> When i move to a record with a different category, the sub-cat values for all records with that category appear and the sub-cats for all other categorys go blank.
>
> 2. Accepting the way things are in issue 1, up until recently I have been able to filter by sub-cat and sort by the sub-cat field in datasheet view but now when I try to do this no records are shown.
>
> Any help with either or both of these issues would be appreciated.
>
> Phil
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar