Record in subform not updating

[Guest]

Hi I have an unbound form with command buttons that when selected will
update 2 fields in a subform and initiate ( make visible and set focus) a
combobox for the user to select the option for a third field in subform. This
works and further code updates date field and invoice number field. Then
moves the focus back to the unbound form for further selections. That works!
However, When I make the next selection from the unbound form the first
record in the bound subform changes . ie dosen't go the the next blank record
..
Suggestions please
Eric

 

[Guest]

I've found the same thing sometimes. The way i've rectified the problem is
using the AfterUpdate property and using

DoCmd.GoToRecord, ,acNewRec

This way the next time you use the set focus, it will go there.... perhaps
you could even put that in your combobox afterupdate code.