>I'm using a form to browse and create records.
>the browse works fine, however the create is
>having problems.
>I have the code to create a record in a menu
>command button since I use this form for two
>purposes.
>When I create a record the record appends to the
>database, a field is updated with a new value, but
>the remaining fields show info for the first record
>in the database instead of blanking.
>Refresh does not seem to work, it's as if the objects
>in the form will not refresh. they do when they are
>accessed, but not on refresh of the form.
>If I place the code within the form it runs fine.
>Does modal or modeless effect this situation?

after you append the record, refresh the form. this will update the objects and (should) show blank info for all fields w/ that table as data source.