P
Perico
(Pavel - thanks for the help on the command button.)
I have an Access2k front end and MS SQL2k back end. When
I add a record in the form via code using an ADO
connection to the backend via a DSN, the form does not
show the new record. However, the record shows in the
back end table.
The form is based on an Access query that is based on the
tables linked to the back end.
I've tried using DAO to requery the Access query, ADO to
requery the SQL backend, and I've refreshed the form.
Still, you have to close and reopen the form to see the
record. What am I doing wrong?
I have an Access2k front end and MS SQL2k back end. When
I add a record in the form via code using an ADO
connection to the backend via a DSN, the form does not
show the new record. However, the record shows in the
back end table.
The form is based on an Access query that is based on the
tables linked to the back end.
I've tried using DAO to requery the Access query, ADO to
requery the SQL backend, and I've refreshed the form.
Still, you have to close and reopen the form to see the
record. What am I doing wrong?