Recent content by Neil_in_Japan

I set the successful filter against a combo box. Works fine.

Actually, HR tech is not a number field, but a lookup field to another table. The field HR Tech contains ID/Full name/Email Address in columns 0,1,2 , respectively. Which only added to the confusion. However, I don't have to fiddle with concatenation either, so trade off there.

***** Solved***** First - thanks for all of your help! Very confusing - but I have it solved: Dim tmpHRTech As Variant tmpHRTech = "407" DoCmd.ApplyFilter , "[HR Tech] = " & tmpHRTech & "" Me.FilterOn = True In the previous posts, I had too many quotes within the VB...

The report 'Record Source' is a table. That table has many fields. One field is called HR Tech. HR Tech is populated via a combo box. The combo box has 3 columns (0,1,2) The report displays the HR Tech with column widths 0";1";0" So only displaying the full name, not the email address of 2...

I like your idea a great deal. However, it isn't applicable in this case. My end users would balk if they had to answer a query every time they used the app to see data. My boss also likes the 30K view of the data a report yields. A report allows me to show all the data then, via buttons...

Thank you for your help: However, the code still doesn't work. As I stated before, I am working within a report and only want to filter some of the information, from time to time, based on a field. The field txtHRTech is a text field. I will hide the field from view when done, but I can...

On a report, I have a txtField that is receiving data from a lookup: txtHRTech =[HR Tech].[Column](1) Column 0 is the ID No. Column 1 is the First Name Last Name Column 2 is the Email Address This field is part of a 'group' and all the HRTech data is group together. Works...

Sure: I created an unbound text field and hid it. Let's call it txtDropDown. For the Default value, I used the 'drop down' field's value: =[dropdown].[Column](2) Also in the Control Source: =[dropdown].[column](2) Then in the drop down field, EVENT Tab, I made a macro...

I found a solution - kind of a hack - I am using unbound hidden text fields with default value =[FieldName].[Column](2) Works like a champ... DLookups are slow though..

It is frustrating to me that I can 'see' the data just fine in the form - but I cannot get to it. It is display only. So, essentially you have to create two or more lookups in different forms to get to the same data? I create a table to store the information I create a form to see/add info to...

I feel foolish - but here goes: I have a form. That form has a combo box. That combo box is supported by a field in a table called Issues. That field is a Lookup field to another table called Contact List. So my form combo box is populated via field in a table that references another...

I have been using this site to help me learn and understand access. It is an odd program, but I like it. Also, I greatly appreciate all the help on this site and hope to be able to contribute a well.