I have a form (Quote) with an auto-number ID, on the form at the moment are two subforms that show different items (sub 1 shows partition modules sub 2 shows partition abutments) both forms use the same parts tables to build them.
Both forms are linked to the quote form using the ID.
All works well until the forms is refreshed or re-loaded, subform 1 shows the module names and quantities and blank spaces for the abutment names but shows the quantiews for the abutments, the reverse of this is shown in the abutments subform 2.
When the lists for the variuos types and the detailed parts lists are printed they are correct.
This seems to be only a visual problem.
All based on Access 2003.
Subform 1
SELECT Quote_Modules.ModuleID,
Quote_Modules.QuoteID,
Quote_Modules.ModuleDescription,
Quote_Modules.ModuleQty,
Quote.Style,
Quote.Trim
FROM Quote
INNER JOIN Quote_Modules ON Quote.QuoteID=Quote_Modules.QuoteID
ORDER BY Quote_Modules.ModuleID;
Subform 2
SELECT Quote_Modules.ModuleID,
Quote_Modules.QuoteID,
Quote_Modules.ModuleDescription,
Quote_Modules.ModuleQty,
Quote.Style,
Quote.Trim
FROM Quote
INNER JOIN Quote_Modules ON Quote.QuoteID=Quote_Modules.QuoteID
ORDER BY Quote_Modules.ModuleID;
