Doing Away with Deleted Word - Microsoft Access Forum


	Back to Access Forum Comments List

Doing Away with Deleted Word

Musoke Herbert

3 years ago

A good day developers , I have a Continuous form on which am using a Delete Query to Delete All the Data at one the Use an Append Query to append data to the same Form after Delete, But the Data Doesn't Load instantly on the Form , i immediately see Deleted all over the Form, how can i Do away with this Such that the Data Loads Instantly and no Deleted word in the Continuous Form? Thanks

	Kevin Robertson @Reply 3 years ago
You need to requery the form after your queries have run. Are you using VBA or a Macro?

	Musoke Herbert OP @Reply 3 years ago
Am using VBA

	Musoke Herbert OP @Reply 3 years ago
Thanks Kevin Robertson, Requery is working Well, God Bless

	Kevin Robertson @Reply 3 years ago
After the lines of code to run your Queries add `Me.Requery`

	Musoke Herbert OP @Reply 3 years ago
Hullo Me.Requery eventually Produces An Error . What Could be the Problem

	Kevin Robertson @Reply 3 years ago
What's the error? What event are you using? Screenshots?

	Musoke Herbert OP @Reply 3 years ago

	Musoke Herbert OP @Reply 3 years ago
That is the Screen shot, the first docmd.runquery and appending data to a table the the Next Docmd.RunQuery is the Delete Query that should Delete the Data after Using it, so the Requery brings in that Error Like its Highlighetd in Yellow

	Kevin Robertson @Reply 3 years ago
Was there an error dialog displayed?

	Musoke Herbert OP @Reply 3 years ago
Yes, please there is the usual error msg

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen