How to auto populate in tex box form

[kft10]

Hi All,



I have created a form that have many fields, some of the fields are repeated from the previous records (have the same contain as the previous records) such as lawyer name, location etc. My question is, can I create a text box (not combo box) to auto populate for those fields that have the same as the previous records?

So, basically I'd like to create the text box that have the same feature as MS Excel. if we already entered data in the previous row (records) for example 'ABC Community Health Center' in field 'Location', when we type the first 2 or 3 character ('ABC') on the that field, the system will complete the rest of the words (ABC Community Health Center). If someone in the forum can give me an idea, I really appreciate it.

Thank in advance.

Regards,
KFT

[Dal Jeanis]

Hi KFT.

Sure, there's lots of ways to do that. You can, for example, load a dropdown box (a combo box) with the values for a field that have been used before, and the user can select them with the mouse or by typing the first few letters to get an autofill.

The combo box, for example called cboLocation, would have its RowSource property set to say something like "SELECT Location from MyTable, ORDER BY LOCATION;" You would probably set the LimitToList property to No, so the user could also add new ones.

[Bob Fitz]

Alternatively, you could put the following line of code in the After Update event of "Location":

    Me.ActiveControl.DefaultValue = Me.ActiveControl

[June7]

Use both ideas. The combobox to select values in first record and the code to set DefaultValue property so data will automatically populate in next record.