Search results

Yup. I have an On Close event that DELETEs the username from the table.

Hello All, I have a hidden form that loads when the database is open that has a few events on the Form_Load event (see below). So far, the code is working great. It does exactly what I need and then some but I would like to have an additional event that checks the username in the...

My language is English. I guess I missed that. I am working remotely on an ipad and the text size is smaller than im used to. Thanks for your help, i appreciate it very much.

Works perfectly. WTH did i miss? I thought I was using the exact code, where did i go wrong?

I’ve tried your suggestions. They only add single or double quotes to the front of the name of the prompt box.

This is what i am using: DoCmd.OpenForm "AuditClicksUsers", acFormDS, , "[User]=’" & Me.Logged_In & “‘“, , acWindowNormal This is the result, “arivera” is a user on the list of Logged_in:

No error. It gives me the prompt i posted earlier, the prompt for entering the parameter value using the Logged_in value as the name of the prompt. If I type the value in the parameter box it will do what I need but I need it to simply go directly to the form with filtered by the user name.

This is the code I am using currently, does the same thing. None of the usernames have single quotes around them

Yes. Always.

I dont know what you mean by “domain full?” and the user field is string

Thanks ZeroAccess, it looks like this gets me closer. When I run the code (click on the field) it gives me a prompt to enter the parameter and the NAME of the prompt is the name represented by the Me.logged_in (see below). It looks like I need to add something that will just use the value AS...

Yes. The Data entry setting is off

It looks like it is not picking up the filter or the value from the subform

It doesnt display the filter term and Yes, there are a lot of records. Maybe I am not including the filter correctly? Should I be using the FILTER condition instead?

It opens the form but does not show any records. It is filtered but there are no corresponding records.

Hello all, I am trying to run this code in the OnClick command of a field on a sub-form. The subform is in Continuous and displays records that are available in realtime. This is the code: DoCmd.OpenForm "AuditClicksUsers", acFormDS, , “User = ‘“ & Me.Logged_In.Value & “‘“, , ...

The subforms are set to view as "Continuous"