Search Form

[connerlowen]

Hi,

I have a database that is used to generate quotations. I have a form that I want to use to Re-Quote something. By Re-Quote, I mean I want the employee to be able to go in and search for the Part desired for Re-Quoting and create a new quotation with all of the information from that part and have the ability to change any of the information as needed. The Form is unbound, and has tab control with three tabs. I would like to search by three different categories "QuotationNumber", "Customer", Or "PartNumber". How do I have the combobox filter the list box below based on what is being typed in the combobox?

If there is any needed additional information please let me know.

Thanks,

Conner Owen

 

[burrina]

Can't you just do that from the form that contains that info? Example:

 Find the record that matches the control.
    Dim rs As Object

   
    Set rs = Me.Recordset.Clone
    rs.FindFirst "[jobid] = " & str(Nz(Me![cbosearch], 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark

 

[connerlowen]

There is no form that contains all of that information. Only forms and subforma that are used to enter all of that information.

 

[burrina]

Those forms refer to table/queries for the data and so you use that as the criteria on your form for a search. Also, if you do a search, there are already pre-built search forms that you might be able to use.

Good Luck !

 

[connerlowen]

If my Tables are linked, can I create the search form based on a query with the first table in the one-to-many relationships and then on click of the correct record, the rest of the information comes up?

 

[burrina]

You can have an unbound search form and then bind the control on the form to the value in your query.
Criteria in your query = [Forms]![yourformnamehere]![controlonyourformhere]

 

[connerlowen]

I am working off of a template I found. Thanks for your help.