Search results

Just tested it...that's what it was, awesome thanks

Probably not, but anyway I don't know what I did but I seem to have fixed the error. It may actually have been just taking out the requery...

yeah that's how it is, then when you select a number it changes back to a textbox, puts the number in the textbox and the afterupdate event of the textbox does a findrecord for the phone number and displays the rest of the contact info

yeah but the if statement only triggers the code when the text in the box is the area code

Code Here's the code for the sub that's giving the error, only happens on some entries though Private Sub txtWorkPhone_Change() Dim strSQL, strPhone If Me.txtWorkPhone.Text Like "(***)" Then strPhone = Me.txtWorkPhone.Text strSQL = "Select Distinct WorkPhone, Company from ContactPerson Where...

I get a cannot set focus to the control error on a combo box that is populated by what a user enters in a text box, but only on certain entries...the user types in an area code and the combo box populates with all of the contacts with that area code. The area codes that get the error are ones...

How do I get an unbound listbox on a form over to a listbox on a report of that form? I have an unbound listbox that gets populated from a combo box with a list of all the items and a textbox for the quantity. The results go into a seperate table with compound key of repair number and item id...

I guess I can make a main display form from a joinquery that lists all the ra's in order and will still be updatable and then launch the other form/subform that I have when a new entry is needed, shouldn't be too much of a problem I was just hoping there was a way to organize it all on one window

The forms are based on tables so that new entries can be added, the main form is used to search for or enter a contact and then a repair subform is filled out for that contact and added to the repairs table. I just want the form to show and be able to navigate through all of the repairs ordered...

I have a main form frmContacts and a subform sbfRA that has repair requests. These two are linked by the key ContactID. The Repair requests have primary key RA which is autonumbered. I am wondering what the easiest way is to have my navigation buttons go through all the records in the RA...