Saving new record when moving to another record in same subform

[mrk978d]

Hi
I have a subform with records of call details (date, time, subject) - the date and time are autogenerated and subject is a text field. After entering text in the subject field and then clicking on the close button in the main form, or clicking anywhere else in the main form, the record is saved to the table. However, if I enter text in the subject field and then move up to view previous records (within the subform) and then click the close button in the main form the record is not saved in the table. How can I either save the record before allowing the user to move to another record within the subform or before exiting the subform set the focus to the new record so that it will be saved on exit?
Thanks

 

[pr2-eugin]

Normally when you move to another record, Access saves the information. Puzzled it is not doing with yours.

Do you have this text box as Unbound control and Click of the button do a UPDATE Query? Or is this Control Bound?

 

[mrk978d]

Hi
Sorry, am new to this forum...do not understand how the printer utility can help with my query?

 

[David R]

...no one said anything about Printers??

In your Form Design View, click the box in the Top Left. Then go to Properties > Data. Does it have a Record Source?

Now click the field you're worried about. Properties > Data. Does it have a Record Source?

 

[mrk978d]

Thanks for your help (strange, the message about printers has disappeared?!). Anyway, on looking again the records were being saved, but a separate table that was querying these records was not updating. I have now added setfocus and gotorecord to the Close button on the main form so that the query will be updated. It seems to have solved it!