Sorry to REPOST: Multiple combo's

[Adam]

You may have seen my posts before but here we go again:

Ive got 13 combo's ( rig name, owner, world region, rig heading, etc.) and
one table ( MODU ) on one form ( MODU-Form ).

Still can go straight through all them, in order, having each combo filter
the combo box after it ( go from rig name to owner to world region, etc and
it will filter and return the correct results ).

I am still looking for a way to be able to go in any order through the combo
boxes, not just in order 1-13.

Currently i only have a query in each combo rowsource allowing me to go in
order, but the closest visual basic code i have seen to use in the forum
would look like this (assuming i have only the first 4 combo boxes)

Private Sub Rig_Name_AfterUpdate()
If IsNull(Me.ActiveControl) Then
[Owner].RowSource = "SELECT modu.rig_name, modu.owner, modu.world_region, "
modu.Rig_Heading " &_"
"FROM modu" &_
"WHERE modu.rig_name = '"&[forms]![modu-form]![rig name]&"' ;"
Else
[Owner].RowSource = "SELECT modu.rig_name, modu.owner, modu.world_region, "
modu.rig_heading FROM modu;"
End If
End Sub

Thanks for any more advice, and sorry to be reposting!

Also:

I am trying to filter the combo lists essentially. The table has 13 columns,
all different categories of offshore rigs which are what all my combos
represent. The form is needed so someone who has just the project number for
instance can go to the combo box for project number, select one, and then the
other combos will only have the proper info for that project #. So the end
result of my form is just having all the combos have information relating to
one project number.

I do realize it doesnt make much sense to others why I need a form to allow
someone to choose out of 13 boxes to narrow a search, but it is what im
trying.

Im not great with visual basic, but in plain terms it seems like i need a
code that allows every box to have all the values for it if every box is
blank. Once a box has a value selected the code would filter the other 12,
and so on. To me it seems like endless codes would have to be written for
every possible direction through the boxes, but im still hoping someone has
an ace up their sleeve to share.

Hope this helps a little, its complicated to me even.

 

[Jeff Boyce]

Adam

As one of those responding earlier, I can tell you that "how" still depends
on what data you have and how you have it structured. I don't have a clear
enough picture of that yet to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Adam]

Jeff,

An Access form im trying to create is for looking up project numbers, rig
headings, well designations, etc when only knowing some information about the
project in general such as the rig name, or how many mooring lines it has.
The oil rigs are mobile, so they move and change heading/location, so knowing
the rig name would narrow the search by bringing up a few different headings
and locations and other criteria. All the data is located in one table, 13
columns with 48 entries. Most all info can be repeated on a different entry
(rig name's can be listed more than once since they move, # of mooring lines
can be repeated since some rigs share the same number of lines, etc.)

Im not sure what else I can say to clear up what my form looks like or what
I am wanting to do.

If it helps, the 13 different combos are [rig name], [owner], [world
region], [rig heading], [mooring tpye], [mooring spread], [mooring lines],
[hurricane legs], [project number], [field/block], [well designation], [water
depth], [avergae HD], [average HD HUR LN], [date last revised].

Adam

As one of those responding earlier, I can tell you that "how" still depends
on what data you have and how you have it structured. I don't have a clear
enough picture of that yet to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

You may have seen my posts before but here we go again:

Ive got 13 combo's ( rig name, owner, world region, rig heading, etc.) and
one table ( MODU ) on one form ( MODU-Form ).

Still can go straight through all them, in order, having each combo filter
the combo box after it ( go from rig name to owner to world region, etc
and
it will filter and return the correct results ).

I am still looking for a way to be able to go in any order through the
combo
boxes, not just in order 1-13.

Currently i only have a query in each combo rowsource allowing me to go in
order, but the closest visual basic code i have seen to use in the forum
would look like this (assuming i have only the first 4 combo boxes)

Private Sub Rig_Name_AfterUpdate()
If IsNull(Me.ActiveControl) Then
[Owner].RowSource = "SELECT modu.rig_name, modu.owner, modu.world_region,
"
modu.Rig_Heading " &_"
"FROM modu" &_
"WHERE modu.rig_name = '"&[forms]![modu-form]![rig name]&"' ;"
Else
[Owner].RowSource = "SELECT modu.rig_name, modu.owner, modu.world_region,
"
modu.rig_heading FROM modu;"
End If
End Sub

Thanks for any more advice, and sorry to be reposting!

Also:

I am trying to filter the combo lists essentially. The table has 13
columns,
all different categories of offshore rigs which are what all my combos
represent. The form is needed so someone who has just the project number
for
instance can go to the combo box for project number, select one, and then
the
other combos will only have the proper info for that project #. So the end
result of my form is just having all the combos have information relating
to
one project number.

I do realize it doesnt make much sense to others why I need a form to
allow
someone to choose out of 13 boxes to narrow a search, but it is what im
trying.

Im not great with visual basic, but in plain terms it seems like i need a
code that allows every box to have all the values for it if every box is
blank. Once a box has a value selected the code would filter the other 12,
and so on. To me it seems like endless codes would have to be written for
every possible direction through the boxes, but im still hoping someone
has
an ace up their sleeve to share.

Hope this helps a little, its complicated to me even.

 

[Jeff Boyce]

Thanks for the additional information about the column (field) names.

However, since we aren't there, and we don't know your situation as well as
you do, a field named "field/block" or "avergae HD" doesn't really tell us
much about the data. It all starts with the data.

It might help to know more about the actual data that's being stored in
those fields (an example is fine).

I have a hunch that the reason why this is difficult to do is because the
data may not be well-normalized ... and Access doesn't work as easily if you
don't feed it the kind of data it expects.

You've been focusing on the form. Again, it starts with the data, not the
form.

Help us better understand your data and we may be able to help you better
understand how to use a form to display/add/edit your data.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,

An Access form im trying to create is for looking up project numbers, rig
headings, well designations, etc when only knowing some information about
the
project in general such as the rig name, or how many mooring lines it has.
The oil rigs are mobile, so they move and change heading/location, so
knowing
the rig name would narrow the search by bringing up a few different
headings
and locations and other criteria. All the data is located in one table, 13
columns with 48 entries. Most all info can be repeated on a different
entry
(rig name's can be listed more than once since they move, # of mooring
lines
can be repeated since some rigs share the same number of lines, etc.)

Im not sure what else I can say to clear up what my form looks like or
what
I am wanting to do.

If it helps, the 13 different combos are [rig name], [owner], [world
region], [rig heading], [mooring tpye], [mooring spread], [mooring lines],
[hurricane legs], [project number], [field/block], [well designation],
[water
depth], [avergae HD], [average HD HUR LN], [date last revised].

Adam

As one of those responding earlier, I can tell you that "how" still
depends
on what data you have and how you have it structured. I don't have a
clear
enough picture of that yet to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

You may have seen my posts before but here we go again:

Ive got 13 combo's ( rig name, owner, world region, rig heading, etc.)
and
one table ( MODU ) on one form ( MODU-Form ).

Still can go straight through all them, in order, having each combo
filter
the combo box after it ( go from rig name to owner to world region, etc
and
it will filter and return the correct results ).

I am still looking for a way to be able to go in any order through the
combo
boxes, not just in order 1-13.

Currently i only have a query in each combo rowsource allowing me to go
in
order, but the closest visual basic code i have seen to use in the
forum
would look like this (assuming i have only the first 4 combo boxes)

Private Sub Rig_Name_AfterUpdate()
If IsNull(Me.ActiveControl) Then
[Owner].RowSource = "SELECT modu.rig_name, modu.owner,
modu.world_region,
"
modu.Rig_Heading " &_"
"FROM modu" &_
"WHERE modu.rig_name = '"&[forms]![modu-form]![rig name]&"' ;"
Else
[Owner].RowSource = "SELECT modu.rig_name, modu.owner,
modu.world_region,
"
modu.rig_heading FROM modu;"
End If
End Sub

Thanks for any more advice, and sorry to be reposting!

Also:

I am trying to filter the combo lists essentially. The table has 13
columns,
all different categories of offshore rigs which are what all my combos
represent. The form is needed so someone who has just the project
number
for
instance can go to the combo box for project number, select one, and
then
the
other combos will only have the proper info for that project #. So the
end
result of my form is just having all the combos have information
relating
to
one project number.

I do realize it doesnt make much sense to others why I need a form to
allow
someone to choose out of 13 boxes to narrow a search, but it is what im
trying.

Im not great with visual basic, but in plain terms it seems like i need
a
code that allows every box to have all the values for it if every box
is
blank. Once a box has a value selected the code would filter the other
12,
and so on. To me it seems like endless codes would have to be written
for
every possible direction through the boxes, but im still hoping someone
has
an ace up their sleeve to share.

Hope this helps a little, its complicated to me even.

 

[Adam]

Heres an example entry:
Rig Name: Marianas
Owner: Transocean
World region: Gulf of Mexico
Rig Heading: 116 (These indicate direction of the vessel in degrees)
Mooring type: Conventional
Mooring Spread: 30-45-60 ( Mooring line pattern, in degrees)
Mooring Lines: 12
Hurricane legs: Y-4 (type of hurricane legs)
Project Number: 10512
Field/Block: GC 199 (Sea floor is mapped out, and given coordinate blocks,
represented by a letter or two followed by a number)
Well Designation: N/A (Usually a number, letter, or combination)
Water Depth: 2250
Average HD: N/A (horizontal distance from vessel to anchor; always a number)
Average HD HUR LN: N/A ( also horizontal distance to hurricane leg
anchors; a number)
Date Revised: 3/23/2007


Im not sure what normalized data is, or a normalizes table is. I can just
state again that theres only one table, 13 columns with the column headers
being the 13 fields my combo boxes deal with, and i have 48 entries in no
particular order what so ever.

Thanks for the help and trying to understand everything Jeff.

Thanks for the additional information about the column (field) names.

However, since we aren't there, and we don't know your situation as well as
you do, a field named "field/block" or "avergae HD" doesn't really tell us
much about the data. It all starts with the data.

It might help to know more about the actual data that's being stored in
those fields (an example is fine).

I have a hunch that the reason why this is difficult to do is because the
data may not be well-normalized ... and Access doesn't work as easily if you
don't feed it the kind of data it expects.

You've been focusing on the form. Again, it starts with the data, not the
form.

Help us better understand your data and we may be able to help you better
understand how to use a form to display/add/edit your data.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,

An Access form im trying to create is for looking up project numbers, rig
headings, well designations, etc when only knowing some information about
the
project in general such as the rig name, or how many mooring lines it has.
The oil rigs are mobile, so they move and change heading/location, so
knowing
the rig name would narrow the search by bringing up a few different
headings
and locations and other criteria. All the data is located in one table, 13
columns with 48 entries. Most all info can be repeated on a different
entry
(rig name's can be listed more than once since they move, # of mooring
lines
can be repeated since some rigs share the same number of lines, etc.)

Im not sure what else I can say to clear up what my form looks like or
what
I am wanting to do.

If it helps, the 13 different combos are [rig name], [owner], [world
region], [rig heading], [mooring tpye], [mooring spread], [mooring lines],
[hurricane legs], [project number], [field/block], [well designation],
[water
depth], [avergae HD], [average HD HUR LN], [date last revised].

Adam

As one of those responding earlier, I can tell you that "how" still
depends
on what data you have and how you have it structured. I don't have a
clear
enough picture of that yet to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

You may have seen my posts before but here we go again:

Ive got 13 combo's ( rig name, owner, world region, rig heading, etc.)
and
one table ( MODU ) on one form ( MODU-Form ).

Still can go straight through all them, in order, having each combo
filter
the combo box after it ( go from rig name to owner to world region, etc
and
it will filter and return the correct results ).

I am still looking for a way to be able to go in any order through the
combo
boxes, not just in order 1-13.

Currently i only have a query in each combo rowsource allowing me to go
in
order, but the closest visual basic code i have seen to use in the
forum
would look like this (assuming i have only the first 4 combo boxes)

Private Sub Rig_Name_AfterUpdate()
If IsNull(Me.ActiveControl) Then
[Owner].RowSource = "SELECT modu.rig_name, modu.owner,
modu.world_region,
"
modu.Rig_Heading " &_"
"FROM modu" &_
"WHERE modu.rig_name = '"&[forms]![modu-form]![rig name]&"' ;"
Else
[Owner].RowSource = "SELECT modu.rig_name, modu.owner,
modu.world_region,
"
modu.rig_heading FROM modu;"
End If
End Sub

Thanks for any more advice, and sorry to be reposting!

Also:

I am trying to filter the combo lists essentially. The table has 13
columns,
all different categories of offshore rigs which are what all my combos
represent. The form is needed so someone who has just the project
number
for
instance can go to the combo box for project number, select one, and
then
the
other combos will only have the proper info for that project #. So the
end
result of my form is just having all the combos have information
relating
to
one project number.

I do realize it doesnt make much sense to others why I need a form to
allow
someone to choose out of 13 boxes to narrow a search, but it is what im
trying.

Im not great with visual basic, but in plain terms it seems like i need
a
code that allows every box to have all the values for it if every box
is
blank. Once a box has a value selected the code would filter the other
12,
and so on. To me it seems like endless codes would have to be written
for
every possible direction through the boxes, but im still hoping someone
has
an ace up their sleeve to share.

Hope this helps a little, its complicated to me even.

 

[Jeff Boyce]

Adam

Thanks for the example ... that makes it a lot clearer what you're working
with.

If "normalized" and "relational" are not familiar terms, consider closing
Access for a bit and brushing up on them.

The fact that you have a table with 13 fields is potentially meaningless for
use in Access. I can create a table in Word that has 13 columns but that
doesn't mean it would work well in Access. I can create an Excel
spreadsheet with 13 columns of data but that doesn't mean it will work well
in Access.

The "work well in Access" part is why understanding "normalization" and
"relational database" is important.

Based on the example data you provided, I have a hunch that your data
belongs in a single table. But how have you come to the conclusion that you
need comboboxes for every field?

I can see where it would be helpful to be able to pick a, for example,
"MooringType", from a combobox on a form to cover the type of mooring for a
new rig you are entering. But if you already have a rig/record, and it
already has a mooring type, why would you need a combobox (to pick a
?!different mooring type?).

And your [Depth] field doesn't seem like you'd want to have to pick from a
list of depths ... wouldn't you want to enter (or see) a number in a
textbox?

Let me back up for a second ... are you trying to do this entirely within a
table? If so, step away from Access again! Access tables store data, but
you want to be using Access forms to display it.

Heres an example entry:
Rig Name: Marianas
Owner: Transocean
World region: Gulf of Mexico
Rig Heading: 116 (These indicate direction of the vessel in degrees)
Mooring type: Conventional
Mooring Spread: 30-45-60 ( Mooring line pattern, in degrees)
Mooring Lines: 12
Hurricane legs: Y-4 (type of hurricane legs)
Project Number: 10512
Field/Block: GC 199 (Sea floor is mapped out, and given coordinate
blocks,
represented by a letter or two followed by a number)
Well Designation: N/A (Usually a number, letter, or combination)
Water Depth: 2250
Average HD: N/A (horizontal distance from vessel to anchor; always a
number)
Average HD HUR LN: N/A ( also horizontal distance to hurricane leg
anchors; a number)
Date Revised: 3/23/2007


Im not sure what normalized data is, or a normalizes table is. I can just
state again that theres only one table, 13 columns with the column headers
being the 13 fields my combo boxes deal with, and i have 48 entries in no
particular order what so ever.

Thanks for the help and trying to understand everything Jeff.

Thanks for the additional information about the column (field) names.

However, since we aren't there, and we don't know your situation as well
as
you do, a field named "field/block" or "avergae HD" doesn't really tell
us
much about the data. It all starts with the data.

It might help to know more about the actual data that's being stored in
those fields (an example is fine).

I have a hunch that the reason why this is difficult to do is because the
data may not be well-normalized ... and Access doesn't work as easily if
you
don't feed it the kind of data it expects.

You've been focusing on the form. Again, it starts with the data, not
the
form.

Help us better understand your data and we may be able to help you better
understand how to use a form to display/add/edit your data.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,

An Access form im trying to create is for looking up project numbers,
rig
headings, well designations, etc when only knowing some information
about
the
project in general such as the rig name, or how many mooring lines it
has.
The oil rigs are mobile, so they move and change heading/location, so
knowing
the rig name would narrow the search by bringing up a few different
headings
and locations and other criteria. All the data is located in one table,
13
columns with 48 entries. Most all info can be repeated on a different
entry
(rig name's can be listed more than once since they move, # of mooring
lines
can be repeated since some rigs share the same number of lines, etc.)

Im not sure what else I can say to clear up what my form looks like or
what
I am wanting to do.

If it helps, the 13 different combos are [rig name], [owner], [world
region], [rig heading], [mooring tpye], [mooring spread], [mooring
lines],
[hurricane legs], [project number], [field/block], [well designation],
[water
depth], [avergae HD], [average HD HUR LN], [date last revised].


:

Adam

As one of those responding earlier, I can tell you that "how" still
depends
on what data you have and how you have it structured. I don't have a
clear
enough picture of that yet to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

You may have seen my posts before but here we go again:

Ive got 13 combo's ( rig name, owner, world region, rig heading,
etc.)
and
one table ( MODU ) on one form ( MODU-Form ).

Still can go straight through all them, in order, having each combo
filter
the combo box after it ( go from rig name to owner to world region,
etc
and
it will filter and return the correct results ).

I am still looking for a way to be able to go in any order through
the
combo
boxes, not just in order 1-13.

Currently i only have a query in each combo rowsource allowing me to
go
in
order, but the closest visual basic code i have seen to use in the
forum
would look like this (assuming i have only the first 4 combo boxes)

Private Sub Rig_Name_AfterUpdate()
If IsNull(Me.ActiveControl) Then
[Owner].RowSource = "SELECT modu.rig_name, modu.owner,
modu.world_region,
"
modu.Rig_Heading " &_"
"FROM modu" &_
"WHERE modu.rig_name = '"&[forms]![modu-form]![rig name]&"' ;"
Else
[Owner].RowSource = "SELECT modu.rig_name, modu.owner,
modu.world_region,
"
modu.rig_heading FROM modu;"
End If
End Sub

Thanks for any more advice, and sorry to be reposting!

Also:

I am trying to filter the combo lists essentially. The table has 13
columns,
all different categories of offshore rigs which are what all my
combos
represent. The form is needed so someone who has just the project
number
for
instance can go to the combo box for project number, select one, and
then
the
other combos will only have the proper info for that project #. So
the
end
result of my form is just having all the combos have information
relating
to
one project number.

I do realize it doesnt make much sense to others why I need a form
to
allow
someone to choose out of 13 boxes to narrow a search, but it is what
im
trying.

Im not great with visual basic, but in plain terms it seems like i
need
a
code that allows every box to have all the values for it if every
box
is
blank. Once a box has a value selected the code would filter the
other
12,
and so on. To me it seems like endless codes would have to be
written
for
every possible direction through the boxes, but im still hoping
someone
has
an ace up their sleeve to share.

Hope this helps a little, its complicated to me even.

 

[Adam]

I understand what youre saying concerning why i want to use combo boxes. This
task was given to me, and i may have to discuss with my supervisor how
practical it is to have a form like this.

All my problems aside; Simply, is what I am looking for in the long run even
possible? That is, CAN a form be made with 13 combo's that allows the user to
go in any order they please through them all?

Adam

Thanks for the example ... that makes it a lot clearer what you're working
with.

If "normalized" and "relational" are not familiar terms, consider closing
Access for a bit and brushing up on them.

The fact that you have a table with 13 fields is potentially meaningless for
use in Access. I can create a table in Word that has 13 columns but that
doesn't mean it would work well in Access. I can create an Excel
spreadsheet with 13 columns of data but that doesn't mean it will work well
in Access.

The "work well in Access" part is why understanding "normalization" and
"relational database" is important.

Based on the example data you provided, I have a hunch that your data
belongs in a single table. But how have you come to the conclusion that you
need comboboxes for every field?

I can see where it would be helpful to be able to pick a, for example,
"MooringType", from a combobox on a form to cover the type of mooring for a
new rig you are entering. But if you already have a rig/record, and it
already has a mooring type, why would you need a combobox (to pick a
?!different mooring type?).

And your [Depth] field doesn't seem like you'd want to have to pick from a
list of depths ... wouldn't you want to enter (or see) a number in a
textbox?

Let me back up for a second ... are you trying to do this entirely within a
table? If so, step away from Access again! Access tables store data, but
you want to be using Access forms to display it.

Heres an example entry:
Rig Name: Marianas
Owner: Transocean
World region: Gulf of Mexico
Rig Heading: 116 (These indicate direction of the vessel in degrees)
Mooring type: Conventional
Mooring Spread: 30-45-60 ( Mooring line pattern, in degrees)
Mooring Lines: 12
Hurricane legs: Y-4 (type of hurricane legs)
Project Number: 10512
Field/Block: GC 199 (Sea floor is mapped out, and given coordinate
blocks,
represented by a letter or two followed by a number)
Well Designation: N/A (Usually a number, letter, or combination)
Water Depth: 2250
Average HD: N/A (horizontal distance from vessel to anchor; always a
number)
Average HD HUR LN: N/A ( also horizontal distance to hurricane leg
anchors; a number)
Date Revised: 3/23/2007


Im not sure what normalized data is, or a normalizes table is. I can just
state again that theres only one table, 13 columns with the column headers
being the 13 fields my combo boxes deal with, and i have 48 entries in no
particular order what so ever.

Thanks for the help and trying to understand everything Jeff.

Thanks for the additional information about the column (field) names.

However, since we aren't there, and we don't know your situation as well
as
you do, a field named "field/block" or "avergae HD" doesn't really tell
us
much about the data. It all starts with the data.

It might help to know more about the actual data that's being stored in
those fields (an example is fine).

I have a hunch that the reason why this is difficult to do is because the
data may not be well-normalized ... and Access doesn't work as easily if
you
don't feed it the kind of data it expects.

You've been focusing on the form. Again, it starts with the data, not
the
form.

Help us better understand your data and we may be able to help you better
understand how to use a form to display/add/edit your data.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,

An Access form im trying to create is for looking up project numbers,
rig
headings, well designations, etc when only knowing some information
about
the
project in general such as the rig name, or how many mooring lines it
has.
The oil rigs are mobile, so they move and change heading/location, so
knowing
the rig name would narrow the search by bringing up a few different
headings
and locations and other criteria. All the data is located in one table,
13
columns with 48 entries. Most all info can be repeated on a different
entry
(rig name's can be listed more than once since they move, # of mooring
lines
can be repeated since some rigs share the same number of lines, etc.)

Im not sure what else I can say to clear up what my form looks like or
what
I am wanting to do.

If it helps, the 13 different combos are [rig name], [owner], [world
region], [rig heading], [mooring tpye], [mooring spread], [mooring
lines],
[hurricane legs], [project number], [field/block], [well designation],
[water
depth], [avergae HD], [average HD HUR LN], [date last revised].


:

Adam

As one of those responding earlier, I can tell you that "how" still
depends
on what data you have and how you have it structured. I don't have a
clear
enough picture of that yet to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

You may have seen my posts before but here we go again:

Ive got 13 combo's ( rig name, owner, world region, rig heading,
etc.)
and
one table ( MODU ) on one form ( MODU-Form ).

Still can go straight through all them, in order, having each combo
filter
the combo box after it ( go from rig name to owner to world region,
etc
and
it will filter and return the correct results ).

I am still looking for a way to be able to go in any order through
the
combo
boxes, not just in order 1-13.

Currently i only have a query in each combo rowsource allowing me to
go
in
order, but the closest visual basic code i have seen to use in the
forum
would look like this (assuming i have only the first 4 combo boxes)

Private Sub Rig_Name_AfterUpdate()
If IsNull(Me.ActiveControl) Then
[Owner].RowSource = "SELECT modu.rig_name, modu.owner,
modu.world_region,
"
modu.Rig_Heading " &_"
"FROM modu" &_
"WHERE modu.rig_name = '"&[forms]![modu-form]![rig name]&"' ;"
Else
[Owner].RowSource = "SELECT modu.rig_name, modu.owner,
modu.world_region,
"
modu.rig_heading FROM modu;"
End If
End Sub

Thanks for any more advice, and sorry to be reposting!

Also:

I am trying to filter the combo lists essentially. The table has 13
columns,
all different categories of offshore rigs which are what all my
combos
represent. The form is needed so someone who has just the project
number
for
instance can go to the combo box for project number, select one, and
then
the
other combos will only have the proper info for that project #. So
the
end
result of my form is just having all the combos have information
relating
to
one project number.

I do realize it doesnt make much sense to others why I need a form
to
allow
someone to choose out of 13 boxes to narrow a search, but it is what
im
trying.

Im not great with visual basic, but in plain terms it seems like i
need
a
code that allows every box to have all the values for it if every
box
is
blank. Once a box has a value selected the code would filter the
other
12,
and so on. To me it seems like endless codes would have to be
written
for
every possible direction through the boxes, but im still hoping
someone
has
an ace up their sleeve to share.

Hope this helps a little, its complicated to me even.

 

[RickP99]

Hi guys, I don't mean to intrude here, Jeff, I just wanted to offer a little input. My understanding from the post was that he may be wanting to use unbound combo boxes to act as record filters. Such as with a car database, you may pick out some options (Power Steering, CD, etc) and display any records that meet those criteria. But I could be way off base here.. Adam?

Also, it looks like most of the fields lend themselves to one table. But a couple such as 'World Region' and 'Mooring Type' probably could use their own tables, as there are bound to be repeating values - possibly 'Owner' falls in there too. Not sure about the other data fields.

Hope this helps,
Rick

 

[Jeanette Cunningham]

Adam,
have a look at the sample search form on this site.
http://allenbrowne.com/ser-62.html

Your setup is similar, you have lots of combos.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia