Forms Problem

[OriginalStealth]

I'll try to explain this properly:

1. Form1 has a cmd button that starts reading an .xls
file from 53 locations on the shared drive.

2. Form2 is a pop-up w/these fields:

Headquarters Processed Error Message

3. Once the first .xls is read in and processed form2
should look like this:

Headquarters Processed Error Message
Albany True(check)


3. I'm using DAO to populate the recordsource and it is
doing that. Here is my code:

dim....
set....
With rs
.AddNew
!Headquarters_Name = strHQ
!Processed = True
.Update
End With

4. How do I display the records being processed one at a
time in form2 without closing it. When 1 .xls is
processed I want that update row to show in form2 but I
don't want to close the form.

Thanx in advance
OriginalStealth

 

[Ted Allen]

It sounds like you may just need to requery Form2 such as:

Forms!Form2.Requery

-Ted Allen