Access question - forms

[RevJohn]

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!

[RuralGuy]

1. What code are you using to "Go to the next record"?
2. What code are you using to do this increment?

[NeoPa]

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 :

Call DoCmd.SelectObject(acTable,"YourTable",FALSE)
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.