473,395 Members | 1,422 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Applyfilter

10
hi, can you applyfilter to a form based on what a user will enter in a login screen and have a specific record show up on that form.

the code i already have is this:

DoCmd.ApplyFilter , "LastName = Me.txtLastName"

which a 'Enter Parameter Value' shows up to find that record, but i don't want to do that, i want that record to be already on that form.

thanks
Feb 25 '07 #1
1 1312
willakawill
1,646 1GB
Hi. You can't include control values inside parenthesis. Try this:
Expand|Select|Wrap|Line Numbers
  1. DoCmd.ApplyFilter , "LastName = " & Me.txtLastName.Text
Feb 25 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Michelle Dennard | last post by:
I am attempting to use the ApplyFilter command on a form in access and I am having some questions. Basically I have a form inwhich I select three things that constitute a key for each item. 1)...
2
by: webvigator2k | last post by:
I have a database that I've converted from 8 seperate tables into one cumulative table. instead of having 8 unique tables, there are 8 different tags now (machine1, machine2 etc) that ID every...
4
by: Bob Darlington | last post by:
Can anyone tell me why: DoCmd.ApplyFilter, "ElectID = " & vNewElectID should work in an mdb, but fail when the file is converted to an mde. It fails with a 'Enter Parameter Value: ElectID"...
4
by: Colin Spalding | last post by:
How can I use the ApplyFilter method when both the control source to be filtered, and the filter are variables. I have tried the following syntax: DoCmd.ApplyFilter , "strSubject ='" & strGroup...
3
by: Robert_5032 | last post by:
I cant get my filter to work with variables Its working fine if I "hardcode" the issueType I want to filter on. Works fine: DoCmd.ApplyFilter , "issueType = 1" Works NOT: DoCmd.ApplyFilter ,...
2
by: John Smith | last post by:
The following code will not work for filtering records on a form: DoCmd.ApplyFilter , "Award =" & Not Null I use the following line to filter for a series of Yes/No boxes without trouble: ...
1
by: Jimmy Stewart | last post by:
I have a continuous form with a list of items from a table. One of the fields in the table is "print". this allows the user to select items from the list on the form for printing in a report. on...
7
by: zamir | last post by:
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...
2
by: dkohel | last post by:
What is wrong with the following code? I am trying to filter a form based on the selection of a combobox named cblPRD Dim currentFilter currentFilter = " = '" & Me!cboPRD & "'" Filter =...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.