I have a form in one of my databases that is built based on a table called elements. The field names in the element table are: Element #,(Number Field) Element Name (Text Field) and Element Text (Memo Field). I am looking for a way that when the Element # is filled in the other two fields automatically show the associated data for that element #. So another words the user only has to fill in the element # and the other two fields appear. I know I can do this with a parameters query by using the criteria field but I dont want the form to ask for the criteria. I don't know if I explained this well but I hope you get my idea.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Form / Query Question
- Thread starter tpearo
- Start date
You could also try using a combo list box for this purpose. The combo list box as an auto-complete feature that you could link to your table.
When the user has filled in the value, limited to the list, you could use the Lost_Focus event on the combo box to fire a Docmd option moving the recordset to that record.
When the user has filled in the value, limited to the list, you could use the Lost_Focus event on the combo box to fire a Docmd option moving the recordset to that record.
- Status
Similar threads
- Locked
- Question
