swilson
Posts: 84
|
| Posted: 10/16/2005, 10:31 AM |
|
In a record form (Aircraft), I have a listbox (Listbox1) whose datasource is another table (Color_Codes). All is well.
But, I want to query or limit the resulting listbox choices, which presently results in all records from the entire Color_Codes table.
Here's what I do that works:
(the Color_Codes table includes columns: ID which is Integer, Model which is text, Color which is text, etc...)
Under DataSource ... for the ListBox1, I added a Where with field name Model type Text, set Condition as contains (like '%...%'), set Parameter Source as 172S, set Type as Expression.
This works sort-of. It ignores the S of 172S and returns all Color_Codes records for 172R and 172S. I don't understand why the letter is ignored.
But additionally, I want to set the Parameter Source as AircraftModel which is the text box of the record form.
In other words, I only want the text box choices for this record form to show choices that only pertain to the type of aircraft model.
I'd like to set the Condition of the Where in the Data Source of Listbox1 to be = and the Parameter to be AircraftModel or {Model} or Model which should be its text value.
When I try this, all records are returned. It only works if I type in the contact 172S, but not by using a variable from the form.
Please help.
_________________
It continues to amaze me, how often the solutions to seemingly complex problems are so very simple. |
 |
 |
swilson
Posts: 84
|
| Posted: 10/16/2005, 10:31 AM |
|
I meant constant, not contact.
_________________
It continues to amaze me, how often the solutions to seemingly complex problems are so very simple. |
|
|
|
|
