By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Search form with realtime update as user print in letters

P: n/a
I have a list of companies in a form.
I want the users to be able to print in the name of the company they
are looking for in a textbox
and then ACCESS should update the (continius) form with records of
companies that
holds the text that the user have printed in.
So the textbox should have the "on Change" happening trigged code.
I cant find hove this code should look like....
What I have now is:
DoCmd.ApplyFilter , "Companyname like '*" & Me.Inputtextfield.Value &
"*'"

Thank you for any help!

Robert

Aug 21 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I want to clearify myself:
The above code work somehove but I have problems with:
-After the updated record of companies,Access moves the focus to the
field "Company"
So I have to manually click in the search filed again.
My goal:
-When the filtering is done, the prompt should be still in the
Searchfield and
the prompt should be after the last letter in the Searchfield .
The letters should not be selected (black) cause then they will be
replaced with what I type.

So when the user types volv the lsit of companies shold be filtered to
companies that have volv in their names. And next, if the user
continiue on the filter string with volvo, the filter is extended to
that.

Thank you

Robert

Aug 21 '06 #2

P: n/a
use a combobox with the LimitToList property set to True, and
Autoexpand to True, and set the rowsource of the combobox to a
query/table. Check out the CustomerID combobox in the Orders form in
Northwind. Open the form in design view and check out the properties
tab for that control.

Aug 22 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.