help needed

[mariewhitehead]

I need some help on a database that is set up for work use.

It's rather large and I have no technicial knowledge of access whatsoever so an answer in plain english would be appreciated.

I have attached a picture of the screen that i am having the problem with. The blank fields contain peoples names and addresses. On this page i have to click on "update service user" on the first user, the database opens a seperate page and i enter a few details, then i click to go back to this screen.

When I return back to the screen, the scroll bar is at the top of the list. This is OK when I am doing the first few letters of the alphabet (the users are listed alphabetically) but when i have too use the scroll bar and choose the letters later down the list, then click to update then return to the screen and the scroll barr is not where i left it...ie: it's at the top.

So what I am asking is, is there a way of freezing this scroll bar so it will stay there even when i have navigated away from the screen to update each user?

If someone could answer me this query then I would be most grateful as it's quite time consuming for me to use the scroll bar and find the next person that i need to update.

 

[wazz]

hide form

i think one way would be to hide the first screen (form) instead of close it when you go to the second screen/form. then when you return, unhide it. it should be where you left it. the updates you just made on the second screen won't be seen until/unless you requery the first screen when you return. (i suppose, depending on your environment, there could be issues with not closing the first screen?) hth - w

 

[Mile-O]

Please do not post the same question in multiple forums - it is a waste of peoples' time.

Original Post