Search as I type
- Thread starter Cindy
- Start date
Ok I see what you're talking about.
The problem is anytime you apply a filter on the form it requeries the form (i.e. fetches data) which also causes the cursor to move to the beginning of the first control in the tab order. To avoid this problem you have two options:
1. Re-order the Tab Order of the Details section to make the search box the first control to receive the cursor. Then use the SelStart and SelLength methods of the textbox to move to cursor the end of the text in the Change event.
2. Pull everything into a subform and leave the search box in the main form's header section.
My preference would be 2.
The problem is anytime you apply a filter on the form it requeries the form (i.e. fetches data) which also causes the cursor to move to the beginning of the first control in the tab order. To avoid this problem you have two options:
1. Re-order the Tab Order of the Details section to make the search box the first control to receive the cursor. Then use the SelStart and SelLength methods of the textbox to move to cursor the end of the text in the Change event.
2. Pull everything into a subform and leave the search box in the main form's header section.
My preference would be 2.
- Local time
- Today, 14:18
- Joined
- Feb 19, 2013
- Messages
- 17,762
Sorry I've been neglecting this thread and can see much progress has been made.
The way I intended the code to work is per the attached.
To open the appropriate record, double click on the appropriate row.
The way I intended the code to work is per the attached.
To open the appropriate record, double click on the appropriate row.
I did actually notice it but I didn't want her to keep banging her head :banghead:By the way Cindy, there's a Description property of a field which is there as the name implies.
- Local time
- Today, 14:18
- Joined
- Feb 19, 2013
- Messages
- 17,762
My suggestion would be to rename the field for example
Oxygen Saturation (O2Sat) documented?
as say
OxygenSaturation
and put
Oxygen Saturation (O2Sat) documented?
in the caption property for the field, or my preference, in the associated label on the form.
Oxygen Saturation (O2Sat) documented?
as say
OxygenSaturation
and put
Oxygen Saturation (O2Sat) documented?
in the caption property for the field, or my preference, in the associated label on the form.
hey everyone thanks for your advise. Yes the field names were a nuisance from the beginning. I'd originally intended for data to be entered directly into the table in datasheet view and people insisted on knowing what the real column names were. Well life has progressed since then and I'm nursing a gorgeous lump on my forehead from all that head banging
yes option2 seems like the painless option but if only I can get the subform to behave. It covers everything on the page. Guess I'll go with option1.
Manythanks vbaInet
yes option2 seems like the painless option but if only I can get the subform to behave. It covers everything on the page. Guess I'll go with option1.
Manythanks vbaInet
brilliant! thanks CJ London. I plan on renaming the fields however to be clear, when you say "To open the appropriate record, double click on the appropriate row"
are you referring to the records in the header section? double clicking populates the form itself?
are you referring to the records in the header section? double clicking populates the form itself?
I tried to double click the record in the header section but nothing happened...
is it supposed to populate the form?
I had a issue with the searchbox accepting only one character. I don't see that you changed any event for the searchbox. So just adding a subform/subreport fixed that?
is it supposed to populate the form?
I had a issue with the searchbox accepting only one character. I don't see that you changed any event for the searchbox. So just adding a subform/subreport fixed that?
