Continuous Form Record Focus

Phalanx

Registered User.
Local time
Tomorrow, 00:58
Joined
Dec 29, 2004
Messages
12
I've got a little problem that I wasnt able to solve... lets say i make a Continuous Form based on a table "Test" that contains:
ID | Description
---------------
0..| Test1
1..| Test2
2..| Test3

I add the field "Description" to the form and i want it, for this sample, to show ONLY the description for "ID" 2, in this case it should be "Test2",
My question is: How do I do this? :confused:
 
You should filter the datasource of that Form.

In the property of the Form, in the 'Data' Tab, it gets a 'Filter' section. You can set your filter the datasource of the Form by using the criteria on ID field.

Hope this can help
 
Nope, that wasnt what I've meant...
I need to filter the data source of an object in the form, not the form itself.
 
The ControlSource of each control is a field from the form's RecordSource if the control is bound. If the control is unbound, it contains an expression which could be a DLookup() to obtain a value from some other table. Unbound controls are not updatable and their contents are not saved to the table.
 

Users who are viewing this thread

Back
Top Bottom