If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo Box query for current record
I am sure this is a common issue, but I couldn't find it in my searches....
I have a form bound to a table called entry. The field 'speed' is a combo list that pulls from a query called speedlist. The idea is that you can only pick an applicable speed based on what is entered in the 'machinetype' and 'machinevendor' field. Works fine with one record, but obviously when i add records the query is returning matches for each record in the entry table, not just the current record. That makes my choices in the speed field incorrect. Is there a way to limit the query to just the current record? |
#2
|
|||
|
|||
Combo Box query for current record
Yes, use criteria that reference the form and refresh query once you have
selected the 'machinetype' and 'machinevendor'. To use the form textboxes as criteria reference like this --- [Forms]![YourFormName]![machinetype] [Forms]![YourFormName]![machinevendor] -- KARL DEWEY Build a little - Test a little "Mariano" wrote: I am sure this is a common issue, but I couldn't find it in my searches.... I have a form bound to a table called entry. The field 'speed' is a combo list that pulls from a query called speedlist. The idea is that you can only pick an applicable speed based on what is entered in the 'machinetype' and 'machinevendor' field. Works fine with one record, but obviously when i add records the query is returning matches for each record in the entry table, not just the current record. That makes my choices in the speed field incorrect. Is there a way to limit the query to just the current record? |
#3
|
|||
|
|||
Combo Box query for current record
Ah!
For some reason I didn't think that would work with a bound form, but it worked perfectly. Thanks so much! "KARL DEWEY" wrote: Yes, use criteria that reference the form and refresh query once you have selected the 'machinetype' and 'machinevendor'. To use the form textboxes as criteria reference like this --- [Forms]![YourFormName]![machinetype] [Forms]![YourFormName]![machinevendor] -- KARL DEWEY Build a little - Test a little "Mariano" wrote: I am sure this is a common issue, but I couldn't find it in my searches.... I have a form bound to a table called entry. The field 'speed' is a combo list that pulls from a query called speedlist. The idea is that you can only pick an applicable speed based on what is entered in the 'machinetype' and 'machinevendor' field. Works fine with one record, but obviously when i add records the query is returning matches for each record in the entry table, not just the current record. That makes my choices in the speed field incorrect. Is there a way to limit the query to just the current record? |
Thread Tools | |
Display Modes | |
|
|