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?