form and subform behaviour using a combo to navigate

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

Guest

Main form has a combo using an autonumber ID to find child records using
FindFirst in AfterUpdate of combo.
Main form, combo and subform have their recordsources assigned in the Load
event of the main form. Subform has 30 fields and this can't be changed.
All of the above work as expected.
The annoying behaviour is when user enters the combo to select a different
record, as soon as user clicks the combo the subform data requeries before
any other choice is made in the combo.
Is there any way to stop this behaiour of requering the subform before any
new choice is selected in the combo?
 
Don't worry, further fiddling found the answer. After the main form was made
to allow edits and the combo's on enter and on exit events for allowing and
disallowing edits were removed, the annoying behavior disappeared. Show what
a flash of inspiration can achieve.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open main and sub form blank 1
subform combo box update, access 03 2
Sync Main Form with Subform after Combo Selection 2
Requery subform control to refresh list based on combo box value change 1
Cascading ComboBox on SubForm 6
Access Main form/Subform Navigation 0
Cascading combos in datasheet 0
Requery combo box 4

Back
Top