double select

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form and a subform to display matching records in another table.
I create a new record for the main form elsewhere.
When I bring up the main form the new record shows in the combo box for selection.
I select it.
The combo box shows blank.
I re-select the same record.
The combo box shows the name correctly this time.
If the record has matching records in the other table, it selects the first time and the matching records appear.
This glitch is unique to 'main' records without 'subrecords'
the cbo_AfterUpdate subroutine consists of "Me.Requery"
 
Place

Me.ActiveControl.Requery

in cbo_Enter.

God Bless,

Mark A. Sam

Desert Bear said:
I have a main form and a subform to display matching records in another table.
I create a new record for the main form elsewhere.
When I bring up the main form the new record shows in the combo box for selection.
I select it.
The combo box shows blank.
I re-select the same record.
The combo box shows the name correctly this time.
If the record has matching records in the other table, it selects the
Click to expand...
first time and the matching records appear.
 
Back
Top