ApplyFilter....again

[zamir]

hi, same problem with applyfilter but i'm close.

what i have done so far is a log in screen that takes a username and password and the user name is stored in a variable called StrUserName.

If Me.txtPassword = DLookup("Password", "QryLoginStudent", "UserName = '" & Me.txtUserName & "'") Then

StrUserName = Me.txtUserName

if the username and password match a main screen appears with a command button called student details and behind that button is this code:

DoCmd.OpenForm "frmStudentDetails"
DoCmd.ApplyFilter , "UserName = " & StrUserName

what happens is that when i click on the button student details a 'Enter Parameter Value' appears where i have to type the students username again to view the details.

i was wondering how to just show the students details WITHOUT the 'Enter Parameter Value' . it will just be there on the form already based on the students username.

Thanks

[Killer42]

I think you may need to specify your filter as a parameter of the OpenForm, rather than using ApplyFilter afterward. That being the case, you probably don't want any parameters in the form's underlying query.

This is just a guess, though.

[zamir]

so what are you trying to say try to have it in one line?

[Killer42]

so what are you trying to say try to have it in one line?

Um... I think so.

What I'm saying is to look up the syntax of the DoCmd.OpenForm statement. It includes parameters for filter name and Where condition.

[zamir]

I have followed your advice and tried it, here is the following code:

DoCmd.OpenForm "frmViewStudentDetails", acNormal, "UserName", "StrUserName", acFormPropertySettings, acWindowNormal

The Enter Parameter value still appears but before the form is opened and when you type in a username it gets the wrong details.

I feel whats embolden in the code above maybe the problem but i don't know what it is.

Do i have to consider a different approach, does anyone have any suggestions?

Thanks

[Killer42]

I have followed your advice and tried it, here is the following code:

DoCmd.OpenForm "frmViewStudentDetails", acNormal, "UserName", "StrUserName", acFormPropertySettings, acWindowNormal

The Enter Parameter value still appears but before the form is opened and when you type in a username it gets the wrong details.

I feel whats embolden in the code above maybe the problem but i don't know what it is.

Do i have to consider a different approach, does anyone have any suggestions?

According to online help, the syntax is...

expression.OpenForm(FormName, View, FilterName, WhereCondition, DataMode, WindowMode, OpenArgs)

So you are specifying...

• FormName = "frmViewStudentDetails"
• View = acNormal
• FilterName = "UserName"
• WhereCondition = "StrUserName"
• DataMode = acFormPropertySettings
• WindowMode = acWindowNormal

I'm not too sure about the FilterName (I've always been a bit vague about filters) but I'm pretty sure "StrUserName" is not a valid Where clause. According to the online help again, this should be

A string expression that's a valid SQL WHERE clause without the word WHERE.

So, for this to work I think you need to concatenate your field name (presumably UserName), and equals sign, and the value of StrUserName in single quotes. Try this and see whether it helps...

DoCmd.OpenForm "frmViewStudentDetails", acNormal, , "UserName = '" & StrUserName & "'", acFormPropertySettings, acWindowNormal

For this to work, I think (not certain) that the form (frmViewStudentDetails) needs to be based on a query which returns all the student records. The Where clause is then applied to select just the record(s) you want.

Once again though, I don't have a lot of experience in this area. We may need to try some of the experts in the Access forum. This will be simple stuff for them.

[zamir]

IT WORKS! UNBELIEVABLE

thanks for your help, the code you have given worked.

cheers

[Killer42]

IT WORKS! UNBELIEVABLE

thanks for your help, the code you have given worked.

Great! Glad I could help.