SubForm Field Name event (1 Viewer)
- Thread starter kirkm
- Start date
You must have some code behind the form? When I click on a datasheet column label, all it does is highlight the entire field. I suspect you have code that is causing a requery of the form, thus the reason for why it moves to the first record. The only way you'd know that the current event fires is if you have code for it, and no you cannot cancel the current event. You can prevent moving to record #1 by not requerying. I'm assuming that by "field name is clicked" you mean the field header at the top of the subform.
Yes, the field headers. I wondered about code behind it, so remmed it all out and it still did it. However there is code behind the main form.
I'll make a mockup in a new db and see what happens. Nice to know it shouldn't happen.
I'll make a mockup in a new db and see what happens. Nice to know it shouldn't happen.
Minty
AWF VIP
- Local time
- Today, 02:32
- Joined
- Jul 26, 2013
- Messages
- 10,371
That's because you are effectively selecting all the records by doing that, so by default, it says you are on the first record.
If you changed from datasheet view and made a continuous form that looked like a datasheet, you can make the field header labels do the sorting etc you require without losing track of the record you are on, although it does take more work
If you changed from datasheet view and made a continuous form that looked like a datasheet, you can make the field header labels do the sorting etc you require without losing track of the record you are on, although it does take more work
Minty replied before I had a chance to look but I did repeat the exercise on a test db of my own and see that it does exactly that. Is this behaviour something that you really need to worry about? Or should the answer be like that of the doctor, when the patient says "Doc, it hurts when I do this" to which Doc replied "Well then don't do that". 
OK, all joking aside, you are saying that the record counter indicates 1 of x or that if you are on say, record 100 it jumps back to putting 1 at the top of the view?
My company just arrived so I have to drop out for a while.
OK, all joking aside, you are saying that the record counter indicates 1 of x or that if you are on say, record 100 it jumps back to putting 1 at the top of the view?
My company just arrived so I have to drop out for a while.
If that's how it is so be it. Although a good solution, I discarded continuous Form once realising you could no longer size/move the column widths.
Yes, Micron it's the latter. Selecting the whole column then control-F to search. You could say it makes sense as the search is from Col 1 but I'd have preferred to not do that (and remain where you were if the search found nothing) . Also not run the Current event, which it does, but figured a way around that.
Thanks for the feedback.
Yes, Micron it's the latter. Selecting the whole column then control-F to search. You could say it makes sense as the search is from Col 1 but I'd have preferred to not do that (and remain where you were if the search found nothing) . Also not run the Current event, which it does, but figured a way around that.
Thanks for the feedback.
I may not have expressed what I meant very well because I when I click on the top of a datasheet header, it does change the record counter to say "1 of x" but the records don't move. You seem to be saying they do.
Maybe what you want to do then is take a look at working with a recordset clone. You can search it for a record in a recordset clone and do something if found or nothing if not found, so you don't lose your place in the form record display. Even if you do move off the current record, you can return to your place if you have created a bookmark first.
Maybe what you want to do then is take a look at working with a recordset clone. You can search it for a record in a recordset clone and do something if found or nothing if not found, so you don't lose your place in the form record display. Even if you do move off the current record, you can return to your place if you have created a bookmark first.
You're right! I apologise - display doesn't move unless search succeeds, so it actually is perfect. Guess the record counter threw me.
Thanks for recordset clone idea. I'll remember that. This is all coming togther well now, more is being done the 'right' way rather than my way!
Thanks for recordset clone idea. I'll remember that. This is all coming togther well now, more is being done the 'right' way rather than my way!
