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

get current field in form to setfilter

form employeeID = employeeID in appointment table
[Emp_ID]=[APPOINTMENT]![Emp_ID]

but it shows all data instead of particular employee.
I am wondering how to get the current field of the form.
Dec 15 '13 #1
1 1104
NeoPa
32,556 Expert Mod 16PB
The .Value of a bound control on a form will return the value of that control for the currently selected record.
Dec 15 '13 #2

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

Similar topics

4
by: Eric | last post by:
Hey Everyone.. I have a form that has approximately 7 text fields and 1 checkbox. Generally when this form is submitted(to itself BTW) it works fine, however, when the checkbox is only field...
4
by: M Wells | last post by:
Hi All, Is it possible to dynamically determine the current field element in a form? I ask because I have a 'tab' button on a form, and when a user clicks on it I need to be able to shift the...
1
by: Old Timer | last post by:
I wish to type in a number in my "Code" field, for instance 1060, I then wish the number 1060 to trigger an event that will fill in the next field (township field) For instance, 1060 brings up and...
2
by: Gerry Abbott | last post by:
Hi all. Im using abbreviated field names on a form to optimise space, but would like to display for example, the status bar text of the control, onto the form header, when the control has the...
4
by: bienwell | last post by:
Hi, I have a problem and really need your help. In my web page ASPX, I have some text fields to accept data from users. I did form validation like this : <td class="dataTD" style="HEIGHT:...
3
by: giftron | last post by:
MS Access 2000- I have a table with 200 fields named F001 through F200 and a form to collect data for those fields. I need to execute an event procedure On Exit to do a conversion ie. ...
2
by: koboabe | last post by:
Is there a way to copy the data from a field above the field I am in (Access 2000 query) only if the current field is empty. And then when the current field has a new value in the field above, copy...
4
by: John | last post by:
Hi I have a form with a couple of text boxes and a list box. The user is able to type text in text boxes and add elements to the list box. My question is; how can I persist the values in these...
2
by: julietbrown | last post by:
I want my user to be able to tab through fields on a form, but NOT move to a new record when tabbing gets to the last tab-indexed field. I can detect when tab is pressed within the KeyDown sub, but...
8
by: Lucrecious | last post by:
How do I create a dynamic report based on a query that updates from a select field form? I followed the information from the article here entitled: "Checkbox form to allow user to select query output...
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:
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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
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.