Getting Form to Filter Records On Load

[Dclassen89]

I have a database with a simple login form"agent login" (calls to table for username and login, username is combobox) button that loads second form once logged in, I have another form which displays customer information for workers"agent homepage" Based on a customer information table(with a field for the assigned worker), I want to be able to setup the login form to load the other form with a filter, basically I want the form to display only customer records which will be assigned to specific workers. I am having trouble with the coding. I have a field in the second form with the workers login(for the filter). Is there any way to have my login form filter the records displayed on the second form based on the user which logs in? I am kinda stumped on this one. Any help would be greatly appreciated.

I read tutorials stating I could add to the code in the button on my login form:
DoCmd.OpenForm "AgentView" (something was added here to filter the results on load) I just dont know code at all.



Edit: Even if I cant filter on load, what would be another effective method to display only customer records with a specific employee assigned to them in the table?

[pbaldy]

One way:

http://www.baldyweb.com/wherecondition.htm

[Dclassen89]

Im just confused what to use for the field and control name. Would the field be the text box on my form displaying the worker name and the control be the combobox for the username on the login form?
This is what I came up with but not working
DoCmd.OpenForm "AgentView", , , "Rep = " & Me.cboLogin

Here is Full code

Private Sub Login_Click()
If Me.txtPwd = Me.cboLogin.Column(2) Then
curUser = Me.cboLogin.Column(0)
DoCmd.Close acForm, "LogonForm"
DoCmd.OpenForm "AgentView", , , "Rep = '" & Me.cboLogin.Column(0) & "'"



Else
If ct < 4 Then

[Dclassen89]

I figured it out, THANK YOU!!!! that was the last thing i needed to do to get this database to function

[pbaldy]

Happy to help and welcome to the site by the way!

[Dclassen89]

Happy to help and welcome to the site by the way!

Thank you sir. One more question on this code for the login button. Is it possible to make it filter for both records assigned to an employee AND customer records which have been assigned no employee? The employees are assigned in the customer table which the employee form is based upon.

[pbaldy]

Try

DoCmd.OpenForm "AgentView", , , "Rep = '" & Me.cboLogin.Column(0) & "' OR Rep Is Null"

[Missinglinq]

DoCmd.OpenForm "AgentView", , , "Rep = '" & Me.cboLogin.Column(0) & "' OR Rep Is Null"

Just curious, but doesn't Is Null only work in SQL, not VBA?

Linq ;0)>

[June7]

The WHERE CONDITION argument follows SQL syntax - Is Null works. So does IsNull(Rep).

[pbaldy]

Just curious, but doesn't Is Null only work in SQL, not VBA?

Linq ;0)>

I'm surprised you didn't test it.

[Missinglinq]

I'm surprised you didn't test it.

Having a bad week...but as always, glad to to increase my personal Knowledge Base!

Thanks, June7!

[Dclassen89]

Try

DoCmd.OpenForm "AgentView", , , "Rep = '" & Me.cboLogin.Column(0) & "' OR Rep Is Null"

Exactly what I was looking for. You are really good at this stuff. Needless to say I will be sticking around this forum for advice as this project progresses. I am developing a database to allow agents in a call center to track customers and orders. My first real opportunity and you have helped tremendously with just this little code. Thanks!

[pbaldy]

Happy to help and welcome to the site by the way!