By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Filtering A Query

P: n/a
EI
Hello..

Using Access 2000

I have a table with the following fields:

DataId (Extension ID)
DataDesc (Description of Extension)

I created a Query based on those two fields.

I use the Query as a Lookup for other table where I need to select a
Data Port Id (on the same table I have 5 fields that uses the same
Query)

Everything works fine but I want to do this:

Let's say I have the values:

ExtId ExtDesc
1234 1234 Description
4321 4321 Description

Once I select the 1234 Id on first field when I move to the second
field that uses the same query, I don't want to see "1234" id because
I already selected it.

The same if I created a new record. I don't want to see values I
already selected.

I'd really appreciate any help.

Thank.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
This could be done using comboboxes on a form. You would modify the Row
Source of the next combobox in the line to exclude the value of the
preceding combobox(es). An example for doing this can be found here.

http://www.mvps.org/access/forms/frm0028.htm

--
Wayne Morgan
Microsoft Access MVP
"EI" <em***@email.com> wrote in message
news:pe********************************@4ax.com...
Hello..

Using Access 2000

I have a table with the following fields:

DataId (Extension ID)
DataDesc (Description of Extension)

I created a Query based on those two fields.

I use the Query as a Lookup for other table where I need to select a
Data Port Id (on the same table I have 5 fields that uses the same
Query)

Everything works fine but I want to do this:

Let's say I have the values:

ExtId ExtDesc
1234 1234 Description
4321 4321 Description

Once I select the 1234 Id on first field when I move to the second
field that uses the same query, I don't want to see "1234" id because
I already selected it.

The same if I created a new record. I don't want to see values I
already selected.

I'd really appreciate any help.

Thank.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.