Search results

Private Sub TxtSearch_Change() Dim db As DAO.Database Dim rst As DAO.Recordset Dim vSearchString As String Dim Iref As Long vSearchString = Me.txtSearch.Text Set db = CurrentDb() Set rst = Me.List2.Recordset.Clone rst.FindFirst "Destination Like '" & vSearchString & "*'" If rst.NoMatch Then...

For my database I have a search option which has a; list box - that has the list of destinations text box - to type in a destination which will search the list box and highlight/eliminate all entries that do not match reset button - for the text box the list box works and so does the reset...

I have it worked out now, cheers Dave.

I'm having trouble with my combo boxes. What I'm aiming to do is have a list of locations in the combo box that the user can select from. When they select the specific location, they press a 'search' button and contact information regarding that location is loaded in a pop up form. Unfortunately...

anyone got any ideas?

Well, the 'add' button is to add the selected record (in this case cheese pizza) in the loaded form to the order subform. So, orders can be added and deleted from the subform without being deleted from the actual table itself... Hope that makes sense..

I'm having a bit of trouble with my database, and i really need some help. For my database I want what is illustrated in the attached image; I've managed to do the first part; searching through tables and loading a form for the desired data entered in the txtsearch, but I can't seem to be able...