My DB is in Access 2002.
Right now my form displays information based on a Cord Blood Table. However, when a new sample is added into the table, it's information is not displayed in the form until the form is closed then opened again. When I look at the bottom of the form, the recordset size does not even changed when a new record is added in the table. So the form definately can't display something that is not even in its set of records.
My question is: Is there any command to update the recordset or any other way for the form to be updated so that the information of the newly-added item will be displayed in the form (when I scroll to it from the bottom arrows) without closing then opening it. (Maybe if a made an update button to click on...what code would I put under OnClick)
Or if there is no way to do the above. Is there any way I can make a button to close and then reopen the form??
THANKS.
Right now my form displays information based on a Cord Blood Table. However, when a new sample is added into the table, it's information is not displayed in the form until the form is closed then opened again. When I look at the bottom of the form, the recordset size does not even changed when a new record is added in the table. So the form definately can't display something that is not even in its set of records.
My question is: Is there any command to update the recordset or any other way for the form to be updated so that the information of the newly-added item will be displayed in the form (when I scroll to it from the bottom arrows) without closing then opening it. (Maybe if a made an update button to click on...what code would I put under OnClick)
Or if there is no way to do the above. Is there any way I can make a button to close and then reopen the form??
THANKS.