Save Macro

[Guest]

I have a main form bound to a parent table and a sub form bound to a child
table. THe child table has a combo box that the user can enter only items
already in the table. I have created a form to add items to this table. I
have created a command button to go to this 'add to' form. After the new item
is added to the table, I created a Save button. However, when the user clicks
the 'Return to 1st Form' button and attempts to add this new item to the
form, an error message "The text you entered isn't an item in the list.
Select an item from the list or enter text that matches one of the listed
items."
After I close out the form and reopen it, the item is available to be
entered.
I tried to use the Save macro with the On Click event for the Save command
button, without success.
I have an Access 2003 text and have read and re-read on line help but no luck.
Can you help?
Thanks in advance.

 

[Steve Schapel]

Stampkelly,

There is no need for a Save button/macro. Newly entered/edited records
are automatically saved when you close the form. or move to another
record, or move between a main form and a subform.

If I understand you correctly, I think you will need to apply a Requery
macro to the combobox. Perhaps this action could be added to the macro
on the Click event of your 'Return to 1st form' command button.