473,385 Members | 1,661 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,385 software developers and data experts.

Changing criteria

5
Hello. How is it possible to have a query which will change its criteria accordingly to a textbox on a form. For example typing the clients number in a textbox will return me the rest of its information which is in the query.

Thanks for any help..
Apr 25 '07 #1
3 1252
MMcCarthy
14,534 Expert Mod 8TB
Hello. How is it possible to have a query which will change its criteria accordingly to a textbox on a form. For example typing the clients number in a textbox will return me the rest of its information which is in the query.

Thanks for any help..
As long as the form is open you can put

Expand|Select|Wrap|Line Numbers
  1. Forms![FormName]![TextboxName]
in the criteria
Apr 25 '07 #2
Knuxus
5
As long as the form is open you can put

Expand|Select|Wrap|Line Numbers
  1. Forms![FormName]![TextboxName]
in the criteria
Thanks it worked.
Apr 25 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
Thanks it worked.
You're welcome.
Apr 25 '07 #4

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

Similar topics

1
by: windandwaves | last post by:
Hi Folk, Below is a message that I posted on alt.html I now have some more feedback from people who experienced an error with safari and they tell me that the PHPsessID changes while running a...
10
by: Marizel | last post by:
I'm not sure there's an easy solution to this, but thought I'd ask. I often find myself with a query which I'd like to reuse, but with a different datasource. These datasources generally have...
1
by: jphelan | last post by:
I ran a MS Access Analyzer program that suggested changing, "rst.FindFirst strcriteria" to using the, "Seek" instead. I tried making the change. I get a Compile error that says, "Argument is not...
3
by: luna | last post by:
is there a way of changing the state of a drop down list to a text box depending on criteria ? i could create a drop down list and a text box list in the same posistion and change the visibility...
3
by: slayerx | last post by:
i've designed a query but i'll want the user to change the criteria within the report. so as the report is open it will show a combo box with a list of names taken from the field in the query, is...
1
by: jaegertw2 | last post by:
I've been working on this for a while and I can't get the syntax right. I'm trying to use code to change the criteria of a stored query so I can toggle whether or not Null values are included in the...
2
by: cek172 | last post by:
Is there any way to change the recordsource of a subform from the mainform? I have a subform that I would like to have return data from a table based on selections from multiple checkboxes on the...
1
by: DrJarmin | last post by:
Hello The problem is this: in the criteria for a list box I reference the parent form - and Access KEEPS changing the criteria for one that won't work. Details below: I have a couple of list...
3
by: Darkside12 | last post by:
Hi, I'm trying to build a dynamic query by form. The idea is that a user can select a table in the database via a combo box and this will then change all of the text box labels on the form to...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
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
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...

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.