Search results

Rich, I apologize for being such a complete idiot on this, but how do I go about doing what you explained? Can I not just attach my db as it is now? I think everything in there is needed to use the whole db. I appreciate your help on this. :o

Thanks again Rich. How can I attach my db on the forum here? I would be appreciate it if you could take a look at it. Have a great weekend.

Thank you again Rich for coming to my rescue. The part you sent worked out well, but when I tried to do it for the "Property" combo box it failed big time. First I used the following: ************************ Private Sub Combo212_AfterUpdate() Me.Filter = "[PropertyID] = " & Me.[Combo212]...

I have a table called Contacts and a form with two combo boxes for searching for records either by name or property name. The following code works fine for finding the first record, but I want to be able to show on the form all (and only) those records which match the combo box entry. Currently...

Thanks for the reply. I think I might have it licked. :rolleyes: I moved the code I had for the PropertyID GotFocus to the Date GotFocus (Date is actually the first field I want the users to see and use) and it works like a charm. I don't really need / want to display the key field to the...

Subform has always been on the main form with Master/Child fields linked. What I am currently trying is the following code somewhere: If IsNull(Me.PropertyID) Then Me.PropertyID.Value = [Forms]![Contacts]![PropertyID] End If I have tried it in both the subforms open and current events with...

I solved that problem with a WhereCondition in the OpenForm code, BUT now I have discovered ANOTHER problem. Aaargh. When I move to a record on the main form that hasn't had a call logged (or say, a new record), the subform does not show the PropertyID value from the main form. I can enter a...

I have a table of contacts and a table of calls logged. They are related based on the (main) Contacts table PropertyID field with the same field in the Calls table. I have a main form for the Contacts table and a subform for the Calls table. I open the subform with a command button on the main...

Works like a charm, my friend. I feel like a moron. The only field names that have spaces are the name fields. I don't know why I did that. I usually don't include spaces just for that reason. I appreciate your help tremendously. I still have a ways to go, so if I'm stuck again, look for another...

Still no luck I'm afraid. After making those changes, I got two "Enter Parameter Value" msgbox pop ups for both the LastName1 and LastName2 values. Do they need to be in [] in the SQL statement or some other minor adjustment to the SQL statement? This is quite a difficult problem - any help is...

Forget that last bit about the query. That was something I was playing around with that didn't work in the end. The SQL statement (provided by Access) is: SELECT Contacts.PropertyID, Contacts.[Last Name1], Contacts.[Last Name2] FROM Contacts; It creates two columns, one for each last name. I...

The code I have is the following: '********************************* Private Sub Combo210_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[PropertyID] = " & Str(Nz(Me![Combo210], 0)) If Not rs.EOF Then...

Hi. Basically, the form I'm working with has a bottom section for data entry / display and a top section for searching for a particular record. So I would like to have the users search for a property (which is the unique part of the record) by entering the contact last name which should fill in...

need help with form lookup I apologize for an unclear representation of my problem to begin with, but here is the basic problem: I have a table of contacts (based on the contact management dB template in Access). It is a database to track real estate properties. The table is set up to hold two...

Hi all. I have a contact dB with 2 contacts (main & alternate). I would like to be able to pull any record containing either the main or alt last name up. Right now the unbound combo box works fine pulling up the first contact name but I need to be able to pull up a record if the second contact...