Replies

Thank you, that works. However, the field in the MainTbl is now TypeID and is a numeric field, but all the entries (inlcuding a trial entry to see how it works) are text. Is that how it should be?

Thank you, Hans. I can see how the filters work. You changed the ‘type’ table, adding a primary key. But that now shows only the Autoid # in the form. How can I get the form to show the text rather than the autoid?

The db I sent was for ‘filter / search a form (2003)’, not this thread. Sorry

Thank you- I’m sending it along.

I’ve tried to follow your instructions, but I don’t get the desired result.

I added a new table with all the staff names, called Staffname. I set up 2 fields, one named NameFilter and the other DescripFilter. I set NameFilter row source to the column in the Staffname table, and made the After Update
Private Sub NameFilter_AfterUpdate()
Me.DescripFilter.Requery
End Sub

For the DescripFilter, I made a query alled NameFilter, with column 3 having the project brief description. And the After Update to
Private Sub DescripFilter_AfterUpdate()
Dim rst As Object
Dim strWhere As String
If Not IsNull(MainFrm.DescripFilter) Then
Set rst = Me.Recordset.Clone
strWhere = “Person = ” & Chr(34) & Me.NameFilter & Chr(34) & _
” And Description = ” & Chr(34) & Me.DescripFilter & Chr(34)
rst.FindFirst strWhere
Me.Bookmark = rst.Bookmark
End If
End Sub

When I choose a name from the NameFilter combo box, nothing happens. Do you have any idea what I did wrong?

Many thanks

Fantastic! Thank you very much. It worked like a charm.
Judy

Pat,
Yes, I am running a query using the two tables, linked by this unique identifier field. One table has the ID as a numeric field, and the other table has it as a text field. That’s where Access says it can’t do it- becasue the fields aren’t the same.
When you said to write that statement, what is the best way to do that? Where should that statement (“”&[ID] as alias) be written?
Thanks so much for your help on this.
Judy

Hans,
Thanks for the reply. There is no way to insert dummy records, unfortunately. I’ll try to attack it some other way.
Judy

Yes, I’m pulling data from a warehouse. I could pull one row for each item, but I have reasons for not wanting to do it that way. I want to pull all items (max 5) in one row.
I’ll keep playing with it- something is bound to occur. Thanks for your help.
Judy

Thank you. I’ll play with that. I’d have to rename every table (up to 10/day) and then modify the field names in the Module for every query. At that point it might be simpler to aggregate each field into Excel and then pivot it. I’m trying to avoid having to make new tables since the tables may have a million or more rows each. But this at least gives me some ideas. I do appreciate it.
Judy

Thank you both- they work wonderfully!

Thank you both- they work wonderfully!

Thanks, Hans. I’ll try that when I get abck to work.
Yes, it’s still the 28th in our world, but perhaps the computer is possessed or in an alternate universe. Most strange!

Thanks, Hans. I’ll try that when I get abck to work.
Yes, it’s still the 28th in our world, but perhaps the computer is possessed or in an alternate universe. Most strange!

The time zone is set correctly for Central time. This is the only ‘date’ function which displays the wrong date. Most puzzling.