> 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
>
> "Adam" discussions.microsoft.com> wrote in message
> news:17E91BC8-15C5-4D7C-AAD7-3FBE597C6A1E@microsoft.com...

>> 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].
>>
>>
>> "Jeff Boyce" wrote:
>>

>>> 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" discussions.microsoft.com> wrote in message
>>> news:F9A774E7-39DA-4D55-BB80-ED4681C7E8A1@microsoft.com...

>>>> 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.

>>>
>>>
>>>

>
>
>