use record id in combobox query

**blaimi** · 11-04-2011, 09:52 AM

Hi,

I have some comboboxes on an endless form. I want to fill the list with values depending on the selected recordset on the form.

I want something like

Code:

SELECT * FROM table WHERE some_col = [TheRecordsetWhichOwnesTheComboboxWhichStartetThisQuery]![ID]

[Form]![FromName]![ID] don't work for this, because it is an endless form so it is null

I googled for it for a while but I couldn't find anything.

I hope you know what I mean and somebody can help me

greets from germany

blaimi

**June7** · 11-04-2011, 01:35 PM

No, don't understand. What is an 'endless form'? Do you want to provide the project for analysis?

**blaimi** · 11-04-2011, 06:02 PM

sorry, I chose a wrong translation. I meant continuous form

**June7** · 11-04-2011, 11:28 PM

Okay, but still don't understand what you want to do. Check out this tutorial, see if that is what you want http://datapigtechnologies.com/flash...tomfilter.html

use record id in combobox query

Thread Tools

use record id in combobox query

Similar Threads

Go to a record that is in a combobox

Combobox selection updates Table record

Setting the display of a combobox after a record is updated

My combobox doesn´t update the selected value when I click on next record

Filter subForm comboBox based on main form combobox selection - With a TWIST

Posting Permissions