behind the GotFocus event of a combo box, i have code for a a requery; however doing so creates this odd effect (which does not happen when the line of code is commented out)
when the user first clicks the combo, the drop-down list opens, the immediately closes.
on a second click, it behaves normally: the drop-down opens and waits for a user action.
involved are (3) tables:
tbeFixtureTypeDetails
tbeSubIssueSchedule
tbeSubIssueSchedule_Types
the user creates a record in tbeSubIssueSchedule
then adds to it records in the related table tbeSubIssueSchedule_Types
entries for tbeSubIssueSchedule_Types are pulled from tbeFixtureTypeDetails
the parent form is a single record form (data source: tbeSubIssueSchedule)
on it is a continuous record SUBform (data source subform tbeSubIssueSchedule_Types)
the COMBOBOX is on this sub form and is used to add records to the table tbeSubIssueSchedule_Types from tbeFixtureTypeDetails
the intent is for the pulldown to show all records in tbeFixtureTypeDetails that are NOT already being used for the current tbeSubIssueSchedule.
behind the combobox i have the ridiculous query (although, it does work, albeit with this strange glitch)
Code:
SELECT tbeFixtureTypeDetails.Type, qrySubSchedule_currentTypesUsed.type
FROM tbeFixtureTypeDetails LEFT JOIN qrySubSchedule_currentTypesUsed ON tbeFixtureTypeDetails.Type = qrySubSchedule_currentTypesUsed.Type
WHERE (((qrySubSchedule_currentTypesUsed.type) Is Null))
ORDER BY TDASort_AlphaCnt([tbeFixtureTypeDetails]![type]), tbeFixtureTypeDetails.Type;
it includes references to the query qrySubSchedule_currentTypesUsed which is
Code:
SELECT tbeSubIssueSchedule_Types.SubIssueTitle, tbeSubIssueSchedule_Types.type
FROM tbeSubIssueSchedule_Types
WHERE (((tbeSubIssueSchedule_Types.SubIssueTitle)=[forms].[frmSubIssueSchedules_Entry].[txtSubIssueTitle]));
I think I've made this FAR more complicated than it ought to be, and I'll appreciate in advance any thoughts, suggestion, direction...
be well, stay healthy,
m.