Recent content by julestrip

Hi, I am having a hard time with the syntax for the From/Where/Or. I want to be able to add several more or's (CustomerFirstName,CustomerAdd1,CustomerST,CustomerZip). My code is below: Private Sub Search_Click() Dim tmp Dim tmp2 Dim strSQL tmp = Me.Search_Criteria strSQL = "SELECT...

Hi, I have a cbo that has this as its rowsource: SELECT tWorkOrder.WorkOrderID, tWorkOrder.CustomerID, tWorkOrder.LocationID, tLocations.LocationName, tLocations.LocationAdd1, tLocations.LocationCity, tLocations.LocationSt FROM tWorkOrder INNER JOIN tLocations ON...

I figured it out...It was the Switchboard Manager that had it all screwed up. When I changed it to Edit the form, it worked perfectly. Thanks for your help! ~High five~

hummmmm... I built it with the wizard....should it find them?

That does nothing to help...the fields still do not update they are blank.

2007 and I did not move it.. Thanks for any help!

Private Sub Lookup_LostFocus() Me!Lookup = Null End Sub AND Macro- Search for record , , First, ="[EmployeeID] = " & Str(Nz(Screen.ActiveControl,0))

Hi, I have a cbo that is supposed to lookup and fill in fields on a form. It worked yesterday and all of the sudden today it doesnt. I tried redoing the cbo and I get the same problem. I used the wizard to create and check the find records on form. Any ideas??? Thanks, Jules

I'll try that... Thanks, Jules

Hi, I have a form with 3 cbo's (Search Field, Search Mode, Lookup ) and a Text box (Search Criteria). I have a query built (qsearch) that pulls in all the possible criteria. What I want to do is pass the value of each cbo to a query and get results. Then the textbox value will narrow down the...

That's a little over my head...I am a newbee...

Hi All ~~~ Hope you had a great weekend! Ok Here is my problem: I have a form that has- ~a combo box that has three choices (Customer, Equipment, Work Order) ~a text box to be used for a Search Criteria ~three subforms tCustomerSubForm1,tEquipmentSubForm1...

I am trying to change the title on a pop up form based on the record from the main form. Such as: Click Martin Smith and see the Pop up title(caption) say Martin Smith with his employee records showing on the form. Thanks for any help!!! Jules

Its all good...I do appreciate you all :)

Thanks for all your help!!!!! I had tried several times to do the trust settings...but had forgotten to select the subfolders....I am working now!!! {{{{High 5's all around}}}