Requery locks record

[Guest]

I use a double-click in a combo box (VBA) to add to a table if a combo box
doesn't have the wanted value, a form then opens to allow additions to
another table. I end the coding with Me!SamplerICID.Requery, then returns to
the entry form. The list gets updated but sometimes the entry form doesn't
allow edits after returning to the empty combo box.
CurtainMary

 

[Gina Whipp]

When I'm trying to 'refresh' a combo box I just added something new to I add
the requery action to the On_Click event of the combo box, ie: DoCmd.Requery
"cboTemperID"

HTH,
Gina Whipp

 

[Guest]

Thnks Gine, I will give that a go later, will let you know
CurtainMary

 

[Guest]

Works fine, thanks Gina
CurtainMary

Thnks Gine, I will give that a go later, will let you know
CurtainMary

 

[Gina Whipp]

Glad to help...

Works fine, thanks Gina
CurtainMary