By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Update Query using VBA

P: n/a
I have an inventory db that I use to catalog tapes.
I am using a tab control with three tabs. One tab is for data entry
and another tab is to view all tapes. My problem is that when I delete
a tape from the data entry screen and then click on the tab to view all
tapes, I see #DELETED in all the fields. I was wondering if there is a
way to rerun the query I use.

Thanks.

Sep 5 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Stout wrote:
I have an inventory db that I use to catalog tapes.
I am using a tab control with three tabs. One tab is for data entry
and another tab is to view all tapes. My problem is that when I delete
a tape from the data entry screen and then click on the tab to view all
tapes, I see #DELETED in all the fields. I was wondering if there is a
way to rerun the query I use.

Thanks.
You have to requery or refresh the subforms on the tabs. You might
want to look up Keri Hardwick's article on Accessweb that details how
to reference all these in code.

www.mvps.org/access go to search (top right), then search away...

Sep 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.