Adding records to a table via a subform

[Jeffrey Marks]

I have a many-to-many relationship between event outings and
participants. On the form for the outing, the user may select
participants from a dropdown box in a subform to add an entry to the
table that links the event outings table and participants table.

I'm running into an issue with the subform. The entry to the link
table is not being created until I go to the next row down on the
subform,. So if I select Albert Adams from the dropdown, no record is
created until I go to the next row in the subform. Is there a way to
correct this?

Thanks

Jeff

 

[Marshall Barton]

I have a many-to-many relationship between event outings and
participants. On the form for the outing, the user may select
participants from a dropdown box in a subform to add an entry to the
table that links the event outings table and participants table.

I'm running into an issue with the subform. The entry to the link
table is not being created until I go to the next row down on the
subform,. So if I select Albert Adams from the dropdown, no record is
created until I go to the next row in the subform. Is there a way to
correct this?

Navigating to a different record is one way to save the
new/changed record and there are many other ways, BUT,
users must do something to indicate that they are done
entering/editing the record's data. Closing the form is
another way and adding a command button to save the record
is another. OTOH, if a user gets mixed up and decides the
record should not be added/changed, they have the option of
undoing the changes to the record so it will not be saved.

What do you want your users to do?

Why do you care when a record is saved?