Recent content by RandyK

Thank you, RandyK

This combo box searches on customer name (drop down list) and automatically goes to that record when I press the "Enter", "Tab" or "Esc" keys or if I "mouse click" on another field. However, I only want it to go to that record if I press the "Enter" key. Sub Combo90_AfterUpdate() ' Find...

Is there a way to setup an Input Mask that forces a "space" after entering a "comma" to separate customer's last name from customer's first name? For example: Doe, John Thank you, RandyK

Shep: Thanks for the quick response. Can the manual or timed refresh (.Requery) occur while the database (datasource) is active with users editting, viewing and/or creating records? What is the downside to a timed refresh and how would you set it up? How about setting up a refresh anytime a...

If user A and user B are accessing the same database at the same time via a form and user A creates a new record, is there a way user B can view or edit this new record without exiting and re-entering the database? RandyK

Thank you.

Instead of selecting the drop down arrow to display all the values, is there a way to setup a combo box to automatically display values in a table by closest match as you type character by character in the combo box field? For example, if I start by entering the the letter "A", a drop down list...