Recordsource not refreshing?

[TimBiesiek]

Hi guys,

I have an access DB, which has a form in that shows records in a continuous form.

In the open event of the form, I run a query to delete all records from a table, and add some new records with another query. I then requery the form, but it displays nothing on the form, even though the table shows over 1000 records.

Private Sub Form_Load()
CurrentDb.Execute "DELETE * FROM CurrentTransfers"
CurrentDb.Execute "QryTransfers"
Me.Requery
End Sub

Any help appreciated!

 

[jebry]

Hi!

Before the requery add:

Call MsgBox "Transferring new records."

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[TheAceMan1]

How are ya TimBiesiek . . .

Try:

[blue]   CurrentDb.Execute "QryTransfers"
   [purple][b]DoEvents[/b][/purple][/blue]

See Ya! . . . . . .

 

[TimBiesiek]

Hi guys,

had tried all those, and got the expected results. The Msgbox displayed, and the doevents didn't help.

Found out that the form properties were set to be data entry. Have played around with this and got it working now, albeit not quite how I was hoping. Am getting closer tho! Thanks!