I have a Master Form. On 2 separate tabs I have a sub form on each. I want to be able to see all records related to the Master on SubformA and on SubformB only the records related to subformA.
To do this I:
Set the supporting query of subformB with criteria
[Forms]![Master]![SubFormA].[Form]![ID] ‘& FieldID which is the link between subforms A and B
I setup an ONCurrent Event on the FORM of subformB:
When I click on tab 3(SubFormB), the First record of subformA shows. If I change the view of the form to datasheet view…the correct records show.
After all that buildup….. How can I only see the records associated with subformA when I click on subform B.
Sometimes MS breaks things just for fun...
In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset.
Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters.
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other.
As you build tables in Microsoft Ac…
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…