Information générale
Catégorie:
Codage, syntaxe et commandes
> Then if I enter a name in the textbox and press ENTER the grid goes blank even if I included the command ThisForm.Refresh().
Whenever you execute the SQL to create table 2, you are destroying, then recreating, the recordsource to which your grid is bound. This causes the grid to lose all data bindings.
Check out the knowledgebase on UT for ways to deal with this issue. There are several options. Probably the most effective method is to bind your grid to a view rather than to a table. In fact, a view is perfect for what you are trying to do.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement