Database User Input

[tarekm]

I am developing a databse system that will be used by other users. I developed a form for data edit and entry. That form is based on a table called Operations. The Operations table has a field called JOB_NUM that is listed in the form. I want the user to enter a value instead of scrolling down a list. Based on this value, the record that has this value will be dispayed.

I will appreciated if someone helped me to do that.

Tarekm

 

[Rohdem]

Here is what I would do: Place an unbound combo box on the form, in this example I will call it lookupbox. Set the rowsource to be the list of job numbers. The user can either select the job number from the list or type it in and hit enter. Then place this code on the 'after update' event of the combobox..

Private Sub lookupbox_AfterUpdate()
Me.RecordsetClone.FindFirst "[job_num] = '" & Me.lookupbox & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

If I understand your question correctly, this should do what you want it to do.


Mike Rohde
rohdem@marshallengines.com