Macro Issues 1

[owizard]

Hi,

I have a Macro that imports a file from excel and stores the the values in a table (say X). I have a command button for running the Macro on the form, which is connected to the table X.

Issues:

1. Whenever I run the Macro, the table gets populated but the form doesn't show the records immediately. I have to close it and reopen it.

2. Is there anyway of replacing the records instead of appending them to the existing records in the table X?


Any Info will be deeply appreciated. Thanks a lot.

 

[SgtJarrow]

2. Simply run a delete macro before running the import macro

1. Requery the form

****************************
Only two things are infinite, the universe and human stupidity,
and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com