as field is selected from combo drop down eliminate it from the li

K

Kelly

Is it possible to have a combo look up in a form that when you click the
dropdown arrow and select one of the records from the list it will take it
out of the dropdown for the next selection? And if by chance they deleted
that selection from that entry it will go back to the list to be selected
again on the next mainform entry?

EXAMPLE:
my subform has a combo box CircNameID

RowSource:
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip FROM CircuitsData ORDER BY
CircuitsData.FromEquip;

The heading is Circuit Name

Kelly
 
K

KARL DEWEY

You might add criteria to the source like this --
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE CircuitsData.CircID Not In (SELECT [YourBoundTable].[YourBoundField]
FROM [YourBoundTable])
ORDER BY CircuitsData.FromEquip;
 
K

Kelly

Karl,
Thanks for the reply. I tried your suggestion but it still shows the ones
you have selected from the drop down as an option. The Combo is CircNameID in
the CircuitDetail table and is looking up the selection listed below. What am
I missing?

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (SELECT [CircuitDetail].[CircNameID]
FROM [CircuitDetail])))
ORDER BY CircuitsData.FromEquip;

Kelly


KARL DEWEY said:
You might add criteria to the source like this --
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE CircuitsData.CircID Not In (SELECT [YourBoundTable].[YourBoundField]
FROM [YourBoundTable])
ORDER BY CircuitsData.FromEquip;

--
Build a little, test a little.


Kelly said:
Is it possible to have a combo look up in a form that when you click the
dropdown arrow and select one of the records from the list it will take it
out of the dropdown for the next selection? And if by chance they deleted
that selection from that entry it will go back to the list to be selected
again on the next mainform entry?

EXAMPLE:
my subform has a combo box CircNameID

RowSource:
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip FROM CircuitsData ORDER BY
CircuitsData.FromEquip;

The heading is Circuit Name

Kelly
Click to expand...
Click to expand...
 
K

KARL DEWEY

You will need a refresh event after selection.
--
Build a little, test a little.


Kelly said:
Karl,
Thanks for the reply. I tried your suggestion but it still shows the ones
you have selected from the drop down as an option. The Combo is CircNameID in
the CircuitDetail table and is looking up the selection listed below. What am
I missing?

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (SELECT [CircuitDetail].[CircNameID]
FROM [CircuitDetail])))
ORDER BY CircuitsData.FromEquip;

Kelly


KARL DEWEY said:
You might add criteria to the source like this --
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE CircuitsData.CircID Not In (SELECT [YourBoundTable].[YourBoundField]
FROM [YourBoundTable])
ORDER BY CircuitsData.FromEquip;

--
Build a little, test a little.


Kelly said:
Is it possible to have a combo look up in a form that when you click the
dropdown arrow and select one of the records from the list it will take it
out of the dropdown for the next selection? And if by chance they deleted
that selection from that entry it will go back to the list to be selected
again on the next mainform entry?

EXAMPLE:
my subform has a combo box CircNameID

RowSource:
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip FROM CircuitsData ORDER BY
CircuitsData.FromEquip;

The heading is Circuit Name

Kelly
Click to expand...
Click to expand...
Click to expand...
 
K

Kelly

How do I do that?
Kelly


KARL DEWEY said:
You will need a refresh event after selection.
--
Build a little, test a little.


Kelly said:
Karl,
Thanks for the reply. I tried your suggestion but it still shows the ones
you have selected from the drop down as an option. The Combo is CircNameID in
the CircuitDetail table and is looking up the selection listed below. What am
I missing?

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (SELECT [CircuitDetail].[CircNameID]
FROM [CircuitDetail])))
ORDER BY CircuitsData.FromEquip;

Kelly


KARL DEWEY said:
You might add criteria to the source like this --
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE CircuitsData.CircID Not In (SELECT [YourBoundTable].[YourBoundField]
FROM [YourBoundTable])
ORDER BY CircuitsData.FromEquip;

--
Build a little, test a little.


:

Is it possible to have a combo look up in a form that when you click the
dropdown arrow and select one of the records from the list it will take it
out of the dropdown for the next selection? And if by chance they deleted
that selection from that entry it will go back to the list to be selected
again on the next mainform entry?

EXAMPLE:
my subform has a combo box CircNameID

RowSource:
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip FROM CircuitsData ORDER BY
CircuitsData.FromEquip;

The heading is Circuit Name

Kelly
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

I like to use macros. Create a macro and use action Refresh and save.
Open the form in design view, click on the combo, double click, scroll down
and select Properties. Scroll to the After Update property. Click the pull
down and select the above macro. Save.

--
Build a little, test a little.


Kelly said:
How do I do that?
Kelly


KARL DEWEY said:
You will need a refresh event after selection.
--
Build a little, test a little.


Kelly said:
Karl,
Thanks for the reply. I tried your suggestion but it still shows the ones
you have selected from the drop down as an option. The Combo is CircNameID in
the CircuitDetail table and is looking up the selection listed below. What am
I missing?

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (SELECT [CircuitDetail].[CircNameID]
FROM [CircuitDetail])))
ORDER BY CircuitsData.FromEquip;

Kelly


:

You might add criteria to the source like this --
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE CircuitsData.CircID Not In (SELECT [YourBoundTable].[YourBoundField]
FROM [YourBoundTable])
ORDER BY CircuitsData.FromEquip;

--
Build a little, test a little.


:

Is it possible to have a combo look up in a form that when you click the
dropdown arrow and select one of the records from the list it will take it
out of the dropdown for the next selection? And if by chance they deleted
that selection from that entry it will go back to the list to be selected
again on the next mainform entry?

EXAMPLE:
my subform has a combo box CircNameID

RowSource:
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip FROM CircuitsData ORDER BY
CircuitsData.FromEquip;

The heading is Circuit Name

Kelly
Click to expand...
Click to expand...
Click to expand...
 
K

Kelly

Karl,
I tried what you suggested placing the where in the SQL for that combo box.
Then made the macro use open query, save, repaintobject and close but all it
does is blink the query but still they all stay in the list.

Kelly


KARL DEWEY said:
I like to use macros. Create a macro and use action Refresh and save.
Open the form in design view, click on the combo, double click, scroll down
and select Properties. Scroll to the After Update property. Click the pull
down and select the above macro. Save.

--
Build a little, test a little.


Kelly said:
How do I do that?
Kelly


KARL DEWEY said:
You will need a refresh event after selection.
--
Build a little, test a little.


:

Karl,
Thanks for the reply. I tried your suggestion but it still shows the ones
you have selected from the drop down as an option. The Combo is CircNameID in
the CircuitDetail table and is looking up the selection listed below. What am
I missing?

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (SELECT [CircuitDetail].[CircNameID]
FROM [CircuitDetail])))
ORDER BY CircuitsData.FromEquip;

Kelly


:

You might add criteria to the source like this --
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE CircuitsData.CircID Not In (SELECT [YourBoundTable].[YourBoundField]
FROM [YourBoundTable])
ORDER BY CircuitsData.FromEquip;

--
Build a little, test a little.


:

Is it possible to have a combo look up in a form that when you click the
dropdown arrow and select one of the records from the list it will take it
out of the dropdown for the next selection? And if by chance they deleted
that selection from that entry it will go back to the list to be selected
again on the next mainform entry?

EXAMPLE:
my subform has a combo box CircNameID

RowSource:
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip FROM CircuitsData ORDER BY
CircuitsData.FromEquip;

The heading is Circuit Name

Kelly
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

Then made the macro use open query, save, repaintobject and close
Huh? Did you try just putting the one action in the marco - Requery -
without arguments?

--
Build a little, test a little.


Kelly said:
Karl,
I tried what you suggested placing the where in the SQL for that combo box.
Then made the macro use open query, save, repaintobject and close but all it
does is blink the query but still they all stay in the list.

Kelly


KARL DEWEY said:
I like to use macros. Create a macro and use action Refresh and save.
Open the form in design view, click on the combo, double click, scroll down
and select Properties. Scroll to the After Update property. Click the pull
down and select the above macro. Save.

--
Build a little, test a little.


Kelly said:
How do I do that?
Kelly


:

You will need a refresh event after selection.
--
Build a little, test a little.


:

Karl,
Thanks for the reply. I tried your suggestion but it still shows the ones
you have selected from the drop down as an option. The Combo is CircNameID in
the CircuitDetail table and is looking up the selection listed below. What am
I missing?

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (SELECT [CircuitDetail].[CircNameID]
FROM [CircuitDetail])))
ORDER BY CircuitsData.FromEquip;

Kelly


:

You might add criteria to the source like this --
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE CircuitsData.CircID Not In (SELECT [YourBoundTable].[YourBoundField]
FROM [YourBoundTable])
ORDER BY CircuitsData.FromEquip;

--
Build a little, test a little.


:

Is it possible to have a combo look up in a form that when you click the
dropdown arrow and select one of the records from the list it will take it
out of the dropdown for the next selection? And if by chance they deleted
that selection from that entry it will go back to the list to be selected
again on the next mainform entry?

EXAMPLE:
my subform has a combo box CircNameID

RowSource:
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip FROM CircuitsData ORDER BY
CircuitsData.FromEquip;

The heading is Circuit Name

Kelly
Click to expand...
Click to expand...
Click to expand...
 
K

Kelly

The macro I had to associate it with a table, query .... that is the reason I
put all those other things in there. If I just use requery for the action and
the control name is NumberOfConductors it tells me it's unavailable. Real
confusing. As you can tell not sure of what I am doing. But I did use

Private Sub NumberOfConductors_AfterUpdate()
DoCmd.GoToRecord , , acNext
DoCmd.GoToRecord , , acPrevious
End Sub

It bounces back to the record but it did update the PercentageOfFill. So
thanks for that idea.

Kelly


KARL DEWEY said:
Huh? Did you try just putting the one action in the marco - Requery -
without arguments?

--
Build a little, test a little.


Kelly said:
Karl,
I tried what you suggested placing the where in the SQL for that combo box.
Then made the macro use open query, save, repaintobject and close but all it
does is blink the query but still they all stay in the list.

Kelly


KARL DEWEY said:
I like to use macros. Create a macro and use action Refresh and save.
Open the form in design view, click on the combo, double click, scroll down
and select Properties. Scroll to the After Update property. Click the pull
down and select the above macro. Save.

--
Build a little, test a little.


:


How do I do that?
Kelly


:

You will need a refresh event after selection.
--
Build a little, test a little.


:

Karl,
Thanks for the reply. I tried your suggestion but it still shows the ones
you have selected from the drop down as an option. The Combo is CircNameID in
the CircuitDetail table and is looking up the selection listed below. What am
I missing?

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (SELECT [CircuitDetail].[CircNameID]
FROM [CircuitDetail])))
ORDER BY CircuitsData.FromEquip;

Kelly


:

You might add criteria to the source like this --
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE CircuitsData.CircID Not In (SELECT [YourBoundTable].[YourBoundField]
FROM [YourBoundTable])
ORDER BY CircuitsData.FromEquip;

--
Build a little, test a little.


:

Is it possible to have a combo look up in a form that when you click the
dropdown arrow and select one of the records from the list it will take it
out of the dropdown for the next selection? And if by chance they deleted
that selection from that entry it will go back to the list to be selected
again on the next mainform entry?

EXAMPLE:
my subform has a combo box CircNameID

RowSource:
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip FROM CircuitsData ORDER BY
CircuitsData.FromEquip;

The heading is Circuit Name

Kelly
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

Did you try the macro action Requery without argument?
--
Build a little, test a little.


Kelly said:
The macro I had to associate it with a table, query .... that is the reason I
put all those other things in there. If I just use requery for the action and
the control name is NumberOfConductors it tells me it's unavailable. Real
confusing. As you can tell not sure of what I am doing. But I did use

Private Sub NumberOfConductors_AfterUpdate()
DoCmd.GoToRecord , , acNext
DoCmd.GoToRecord , , acPrevious
End Sub

It bounces back to the record but it did update the PercentageOfFill. So
thanks for that idea.

Kelly


KARL DEWEY said:
Then made the macro use open query, save, repaintobject and close
Click to expand...
Huh? Did you try just putting the one action in the marco - Requery -
without arguments?

--
Build a little, test a little.


Kelly said:
Karl,
I tried what you suggested placing the where in the SQL for that combo box.
Then made the macro use open query, save, repaintobject and close but all it
does is blink the query but still they all stay in the list.

Kelly


:

I like to use macros. Create a macro and use action Refresh and save.
Open the form in design view, click on the combo, double click, scroll down
and select Properties. Scroll to the After Update property. Click the pull
down and select the above macro. Save.

--
Build a little, test a little.


:


How do I do that?
Kelly


:

You will need a refresh event after selection.
--
Build a little, test a little.


:

Karl,
Thanks for the reply. I tried your suggestion but it still shows the ones
you have selected from the drop down as an option. The Combo is CircNameID in
the CircuitDetail table and is looking up the selection listed below. What am
I missing?

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (SELECT [CircuitDetail].[CircNameID]
FROM [CircuitDetail])))
ORDER BY CircuitsData.FromEquip;

Kelly


:

You might add criteria to the source like this --
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE CircuitsData.CircID Not In (SELECT [YourBoundTable].[YourBoundField]
FROM [YourBoundTable])
ORDER BY CircuitsData.FromEquip;

--
Build a little, test a little.


:

Is it possible to have a combo look up in a form that when you click the
dropdown arrow and select one of the records from the list it will take it
out of the dropdown for the next selection? And if by chance they deleted
that selection from that entry it will go back to the list to be selected
again on the next mainform entry?

EXAMPLE:
my subform has a combo box CircNameID

RowSource:
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip FROM CircuitsData ORDER BY
CircuitsData.FromEquip;

The heading is Circuit Name

Kelly
Click to expand...
Click to expand...
Click to expand...
 
K

Kelly

Yes, that is when is tells me it's not available. I also tried the following

Private Sub NumberOfConductors_AfterUpdate()
DoCmd.Requery
End Sub

This worked but bounced the cursor back to the first field in the datasheet
subform. Why wouldn't this just go to the next tab?

Kelly


KARL DEWEY said:
Did you try the macro action Requery without argument?
--
Build a little, test a little.


Kelly said:
The macro I had to associate it with a table, query .... that is the reason I
put all those other things in there. If I just use requery for the action and
the control name is NumberOfConductors it tells me it's unavailable. Real
confusing. As you can tell not sure of what I am doing. But I did use

Private Sub NumberOfConductors_AfterUpdate()
DoCmd.GoToRecord , , acNext
DoCmd.GoToRecord , , acPrevious
End Sub

It bounces back to the record but it did update the PercentageOfFill. So
thanks for that idea.

Kelly


KARL DEWEY said:
Then made the macro use open query, save, repaintobject and close
Huh? Did you try just putting the one action in the marco - Requery -
without arguments?

--
Build a little, test a little.


:


Karl,
I tried what you suggested placing the where in the SQL for that combo box.
Then made the macro use open query, save, repaintobject and close but all it
does is blink the query but still they all stay in the list.

Kelly


:

I like to use macros. Create a macro and use action Refresh and save.
Open the form in design view, click on the combo, double click, scroll down
and select Properties. Scroll to the After Update property. Click the pull
down and select the above macro. Save.

--
Build a little, test a little.


:


How do I do that?
Kelly


:

You will need a refresh event after selection.
--
Build a little, test a little.


:

Karl,
Thanks for the reply. I tried your suggestion but it still shows the ones
you have selected from the drop down as an option. The Combo is CircNameID in
the CircuitDetail table and is looking up the selection listed below. What am
I missing?

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (SELECT [CircuitDetail].[CircNameID]
FROM [CircuitDetail])))
ORDER BY CircuitsData.FromEquip;

Kelly


:

You might add criteria to the source like this --
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE CircuitsData.CircID Not In (SELECT [YourBoundTable].[YourBoundField]
FROM [YourBoundTable])
ORDER BY CircuitsData.FromEquip;

--
Build a little, test a little.


:

Is it possible to have a combo look up in a form that when you click the
dropdown arrow and select one of the records from the list it will take it
out of the dropdown for the next selection? And if by chance they deleted
that selection from that entry it will go back to the list to be selected
again on the next mainform entry?

EXAMPLE:
my subform has a combo box CircNameID

RowSource:
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip FROM CircuitsData ORDER BY
CircuitsData.FromEquip;

The heading is Circuit Name

Kelly
Click to expand...
Click to expand...
Click to expand...
 
K

Kelly

Karl I tried a different approach and it did eleiminate the ones out of the
dropdown but blanked out the others that were in the report. Instead of using
the lookup (CircNameID) to the table with the data I used the table with the
data. If that makes sense.
This worked but blanked out the fields that were already selected in the
CircNameID field in the subreport.

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (Select CircuitsData.CircID from
CircuitSubformqry where CircuitsData.CircID = CircuitSubformqry.CircID )))
ORDER BY CircuitsData.FromEquip;

The field CircNameID was originally

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
ORDER BY CircuitsData.FromEquip;

The Name and Control source is CircNameID in table CircuitDetail. What am I
missing or am I totally confused? any suggestions are greatly appreciated.

Kelly


KARL DEWEY said:
You might add criteria to the source like this --
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE CircuitsData.CircID Not In (SELECT [YourBoundTable].[YourBoundField]
FROM [YourBoundTable])
ORDER BY CircuitsData.FromEquip;

--
Build a little, test a little.


Kelly said:
Is it possible to have a combo look up in a form that when you click the
dropdown arrow and select one of the records from the list it will take it
out of the dropdown for the next selection? And if by chance they deleted
that selection from that entry it will go back to the list to be selected
again on the next mainform entry?

EXAMPLE:
my subform has a combo box CircNameID

RowSource:
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip FROM CircuitsData ORDER BY
CircuitsData.FromEquip;

The heading is Circuit Name

Kelly
Click to expand...
Click to expand...
 
K

KARL DEWEY

I see error in your subquery. You can not Select CircuitsData.CircID from
CircuitSubformqry.
Either this ---
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (Select CircuitSubformqry.CircID from
CircuitSubformqry where CircuitsData.CircID = CircuitSubformqry.CircID )))
ORDER BY CircuitsData.FromEquip;

Or this ---
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (Select [MyAlias].CircID from
CircuitsData AS [MyAlias] WHERE CircuitsData.CircID = [MyAlias].CircID )))
ORDER BY CircuitsData.FromEquip;

--
Build a little, test a little.


Kelly said:
Karl I tried a different approach and it did eleiminate the ones out of the
dropdown but blanked out the others that were in the report. Instead of using
the lookup (CircNameID) to the table with the data I used the table with the
data. If that makes sense.
This worked but blanked out the fields that were already selected in the
CircNameID field in the subreport.

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE (((CircuitsData.CircID) Not In (Select CircuitsData.CircID from
CircuitSubformqry where CircuitsData.CircID = CircuitSubformqry.CircID )))
ORDER BY CircuitsData.FromEquip;

The field CircNameID was originally

SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
ORDER BY CircuitsData.FromEquip;

The Name and Control source is CircNameID in table CircuitDetail. What am I
missing or am I totally confused? any suggestions are greatly appreciated.

Kelly


KARL DEWEY said:
You might add criteria to the source like this --
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip
FROM CircuitsData
WHERE CircuitsData.CircID Not In (SELECT [YourBoundTable].[YourBoundField]
FROM [YourBoundTable])
ORDER BY CircuitsData.FromEquip;

--
Build a little, test a little.


Kelly said:
Is it possible to have a combo look up in a form that when you click the
dropdown arrow and select one of the records from the list it will take it
out of the dropdown for the next selection? And if by chance they deleted
that selection from that entry it will go back to the list to be selected
again on the next mainform entry?

EXAMPLE:
my subform has a combo box CircNameID

RowSource:
SELECT CircuitsData.CircID, CircuitsData.CircuitName,
CircuitsData.FromEquip, CircuitsData.ToEquip FROM CircuitsData ORDER BY
CircuitsData.FromEquip;

The heading is Circuit Name

Kelly
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically select in a sub form by a number chosen in the main 1
Combo box date format changes when item selected from list 4
Can't scroll combo list 2
Change Address Field data in a Table from a form using Combo Drop 7
How to get one field to update based on a selection from a drop do 1
Combo Box not refreshing after changing Row Source in code 0
Combo query refresh 5
Is it possible for a combo box... 2

Top