Data entry - table not populating immediately (1 Viewer)

[Megacitizen]

My form has been set up to enter and display info. However, the table it goes into is not populating until the user has finished his/her session and closes the form down. We need this info to update earlier, preferably on entry, as we require certain elements to be able to populate other forms.

The MainForm displays all information and the School or Team name is entered through this form, going into the School or Ministry table. This generates an autonumber which is then used in the TeamMember table to identify team members within each team. At the moment, the only way we have access to this autonumber is by shutting the mainform down and then reopening it.

Which event in the property sheet do I require to get the table to populate when the user moves onto next record?

 

[John Big Booty]

If your form is bound to a table, then data entered in the form should be committed to the underlying table as soon as the user moves to a new/previous/next record.

You could commit the data earlier by the form's Dirty property to False as soon as a particular field lost focus.