By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,228 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.

Access question - forms

P: 1
Basic Access User. Using Access2003, I am attempting to do several thnigs, and they are:

1. I need the information I place in the form to show in the Table once I use the command button to go to "new record". As is stands right now, I have to close the table and reopen it to see the information that I update. The text boxes are bound to the Table fields.

2. I have a second set of command buttons that are used like a "clicker", hit the button and it adds, incrmentally (+1) to the total. The code is working fine for this, however, I have a small "view" window back to the table it feeds. There are 9 categories (buttons), and only one works - although I have the same code and setup for each button.

If this is too confusing, I apologize!! Thank you for your help!
Jun 3 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 375
1. What code are you using to "Go to the next record"?
2. What code are you using to do this increment?
Jun 3 '08 #2

Expert Mod 15k+
P: 31,494
From 1, I assume that you are looking at the contents of the table concurrently as you are running the form. This is not too straightforward, but if there is no filter or sort currently applied, then you can safely use the following concept :
Expand|Select|Wrap|Line Numbers
  1. Call DoCmd.SelectObject(acTable,"YourTable",FALSE)
  2. Call DoCmd.RunCommand(acCmdRemoveFilterSort)
I'm not sure what you're using in 2 as code, but if any one of them works this indicates that the view window is managing to stay up-to-date. We need more details of what your code is doing to what to help further. As it stands, your question is a bit like saying "I have some code that's not working - where is it wrong?" There's not really much to go on.
Jun 6 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.