Populate Form Based on User Entered Data

[stuckincement]

Hi All,

I have a form that displays information out of a table. I added a free-form text field where I would like a user to be able to enter a numeric value that then would be searched in a specific field in the table and then populate the form with that specific record's information. Any ideas?

I have tried this numerous ways in regards to having a macro run but have had no luck. Any help would be greatly appreciated!

 

[ranman256]

The macro idea is correct...the macro would run an update query.
The upd query would look like

"update table Set [myfield] = '" & forms!frmMyForm!txtBoxUpdVal & "'"

 

[stuckincement]

Thanks for your help! I put the update query in but am still having problems. Here is what my SQL code is:

UPDATE tblCharges SET tblCharges.[Trip Number] = '" & [Forms]![frmLTL_Estimated]![Text18] & "';

Text18 is the text box that a user will type in the numeric value to then be matched to the Trip Number field. tblCharges then is the table I would like to have the matching trip number record to be pulled from and displayed on this form.

 

[stuckincement]

In case this thread is useful to anyone else, I was able to find a solution after a lot of hours of trial an error. In the end, I created a combo box on my form tied to the field. I used the following code to take the user entered value and move to that corresponding record:

Me.RecordsetClone.FindFirst "[Trip Number]=" & Me![Combo146]Me.Bookmark = Me.RecordsetClone.Bookmark

The combo box values are input via a quick SQL statement in the row source data field property:

SELECT [tblCharges].[Trip Number] FROM tblCharges ORDER BY [Trip Number];

To avoid an error from the initial open of the form you also need to set the default value - in this case I used the first expression to pull the first record's information to that field.

Hope this helps!