Full Version: Showing Forms list and their control captions on a subform
UtterAccess Forums > Microsoft® Access > Access Forms
KingMartin
Hello,
I am building a multilanguage database and I need to edit the forms' control captions. For easy editing, I want to have a main form with combo showing the forms' name and a subform based on this table:
tblFormsLabels
FormID
FormName
LabelName
LanguageID
LabelCaption
Obased the main form on this query:
CODE
SELECT MSysObjects.Id, MSysObjects.Name
FROM MSysObjects
WHERE (((GetObjectType([Type]))<>"" And (GetObjectType([Type]))="Form") AND ((Left([Name],1))<>"~") AND ((Left([Name],4))<>"msys"))
Order BY tblFormsLabels.FormName, tblFormsLabels.LabelName, tblLanguages.ID;

But I can get it right, I want to be able to pick up the form's name in a combobox on the main form and see the related records below.
I don't know what I am missing. It should be a classical parent-child relation, but it simply doesn't want to work for me.
Thank you
Martin
KingMartin
I got it working, but I needed to write the AfterUpdate code of the combobox at the main form manually, as the find record option was not available in the wizard. I linked the Master and Child IDs and it is working now.
artin
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.