G
Guest
I have a individual account form with two subforms, both attached to my
Journal table. The purpose of the top subform is to add a journal record,
and the purpose of the bottom subform is to list the journal record entries
for edit or deletion in descending order by date.
(I created the layout this way so that the user can enter new journal
records without scrolling to the bottom of the list to enter a new record)
This method still has two problems
1. I have created an "Add" button in the top subform to officially "enter"
the record, but when this button is clicked, I would also like to refresh the
bottom subform to show the newly entered record.
2. If the user presses the tab button after entering a new journal record,
the record is entered automatically. I only want the record to be entered
when the user presses the "Add" button.
Please be clear with any code suggestions, as I'm and not very used to
writing code in Access (I'm used to doing VB code for ASP websites)
Thanks, Amanda
Journal table. The purpose of the top subform is to add a journal record,
and the purpose of the bottom subform is to list the journal record entries
for edit or deletion in descending order by date.
(I created the layout this way so that the user can enter new journal
records without scrolling to the bottom of the list to enter a new record)
This method still has two problems
1. I have created an "Add" button in the top subform to officially "enter"
the record, but when this button is clicked, I would also like to refresh the
bottom subform to show the newly entered record.
2. If the user presses the tab button after entering a new journal record,
the record is entered automatically. I only want the record to be entered
when the user presses the "Add" button.
Please be clear with any code suggestions, as I'm and not very used to
writing code in Access (I'm used to doing VB code for ASP websites)
Thanks, Amanda