Recent content by abbyanu

Hi TheAceMan1 Yip... 1:many, it says - Locations_Internal_Control (location_id, period_id) --< Entity_Evaluation (location_id, period_id, entity_id) I'm using location_id and period_id as composite primary key in the Locations_Internal_Control table. Entity_Evaluation has location_id...

Dear TheAceMan1 I very much appreciate your effort and time. Actually I think I do have the tables normalized, and the Locations_Internal_Control and Entity_Evaluation have a 1:many relationship. But I'm gonna revisit the design and get back to you. Again, many thanks for your assistance. I...

Hi TheAceMan1 I'm not sure that I understand your question. In the Locations Internal Control subform, location_id & period_id constitute a primary key - thus a unique single record. In the Entity Evaluation subform, location_id & period_id, along with entity_id constitute a unique single...

Oops! Lemme keep it short and to the point ;) 1. The link is via Link Master/Child Properties of the subform. 2. Functionality of the comboboxes in the subform... to describe the location (location_id) and the period (period_id) that the entity is being evaluated (entity_id). Indeed, some of...

Hi TheAceMan1 Here's the complete scenario... sorry for the repetition... I want you to have as much info as possible 'cuz I need help ;) Here are the table layouts: * is primary key: Locations: location_ID*, location_name Locations_Internal_Control: location_id*, period_id*...

Thanks, TheAceMan1... I gather you must be in the East Coast ;)

The data datatypes combo boxes in the form Locations Internal Controls are Strings. Indeed... location_id and period_id are the bound columns. The RecordSource is a Table. Hope this helps. Abbyanu.

Yes, sir! That's precisely what I wish to accomplish.

TheAceMan1, I'm reading you.... could and clear. Please go on and share your wisdom ;)

Hi I still can't get it... 'cuz I wish to link to the subform in the Main form. So I'm assuming that we'll link the main form and do the filter on the subform. Am I missing something? Please advise.

Hi TheAceMan1 Many thanks for your assistance... the code works fine, but now this has introduced a new problem...an error message Run-time error '2450' that the database 'can't find the form "Entity" referred to in macro expression or Visual Basic code. I believe the code above assumes that...

Indeed... stLinkCriteria is used in the subform's Filter Property.

Thanks TheAceMan1, I have two forms: "Locations Internal Controls" and "Entity." The "Entity" form has a subform called "Entity Evaluation Subform" and is linked to it via entity_id. The "Locations Internal Controls" form is linked to the "Entity Evaluation Subform" via location_id and...

Oops! Please ignore the second-to-last post.... I accidentally submitted.

This code is running from a command button in a form called "Locations Internal Controls". This form has two combo boxes - location_id and period_id. The second form is called "Entity" and it has a subform called "Entity Evaluation subform". The "Entity Evaluation subform" also has two combo...