Use combo box to force a selection in secondary combo boxes?

[excel-chump]

I have a three combo boxes. Two run as a cascade: "Advocate" selection
limits "Reviewer" selection in subform. What I am trying to accomplish
within the third combo box is a "reverse" lookup: By selecting a "Reviewer"
it will pull up the "Advocate" main form. I got this working, however, when
it pulls up the "Advocate" main form it pulls only the first "Reviewer"
listed under the advocate rather than the selected name.

Where: ODIS ID = Advocate ID, User ID = Reviewer

Here is the SQL query, "reverselookup", I'm using:

SELECT [FR Data].[First Name]+' '+[FR Data].[Last Name] AS Expr1, [FRA
Data].[ODIS ID], [FR Data].[User ID]
FROM [FRA Data] INNER JOIN [FR Data] ON [FRA Data].[ODIS ID]=[FR Data].[FRA
ID]
ORDER BY [FR Data].[First Name]+' '+[FR Data].[Last Name];
-------------------------------
I'm forced to set the ODIS ID as the bound column to update the main form
and I don't know how to write the code to force the selection in the reverse
lookup combo box rather than the first Reviewer with the listed Advocate.
-------------------------------
'This is the code I'm using to show the record on the form:

Private Sub reverselookup_AfterUpdate()

' Find the record that matches the control.

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ODIS ID] = '" & Me![reverselookup] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

End Sub

 

[NetworkTrade]

I can not answer the question in the structure that you ask it.....

It sounds like there is 1:Many for Advocate:Reviewer
....since you say that selecting Advocate filters the Reviewer choices - and
this part you have running ok.

Assumming this relationship structure; selecting Reviewer is able to give a
unique Advocate ID value.

And with that unique Advocate ID value one can of course present all the
Reviewer choices that cross reference to it.

I would create the query (plain vanilla query using query design) that will
present the correct data when a Reviewer is selected on the form; .....then
at least you have the core record source and can decide creatively as to how
best present it whether it be subform/combobox or whatever....

 

[excel/access-chump]

NetworkTrade,

You managed to get the relationships right despite all my mubo-jumbo!

I have created the query you suggested and named it "reverselookup". I set
it up as a combo box with the complete list of Reviewer names and a
corresponding text box that displays the name of that reviewer's advocate.
After which I can use the cascade combo boxes to pull up the corresponding
records.
What I want to do is pare this down into a single operation: By choosing
the reviewer name in the "reverselookup" combo I want the cascade combo boxes
to update.

Please let me know if this clarifies my request at all.

--
Thank you for your help!

-The Chump

I can not answer the question in the structure that you ask it.....

It sounds like there is 1:Many for Advocate:Reviewer
...since you say that selecting Advocate filters the Reviewer choices - and
this part you have running ok.

Assumming this relationship structure; selecting Reviewer is able to give a
unique Advocate ID value.

And with that unique Advocate ID value one can of course present all the
Reviewer choices that cross reference to it.

I would create the query (plain vanilla query using query design) that will
present the correct data when a Reviewer is selected on the form; .....then
at least you have the core record source and can decide creatively as to how
best present it whether it be subform/combobox or whatever....



--
NTC

I have a three combo boxes. Two run as a cascade: "Advocate" selection
limits "Reviewer" selection in subform. What I am trying to accomplish
within the third combo box is a "reverse" lookup: By selecting a "Reviewer"
it will pull up the "Advocate" main form. I got this working, however, when
it pulls up the "Advocate" main form it pulls only the first "Reviewer"
listed under the advocate rather than the selected name.

Where: ODIS ID = Advocate ID, User ID = Reviewer

Here is the SQL query, "reverselookup", I'm using:

SELECT [FR Data].[First Name]+' '+[FR Data].[Last Name] AS Expr1, [FRA
Data].[ODIS ID], [FR Data].[User ID]
FROM [FRA Data] INNER JOIN [FR Data] ON [FRA Data].[ODIS ID]=[FR Data].[FRA
ID]
ORDER BY [FR Data].[First Name]+' '+[FR Data].[Last Name];
-------------------------------
I'm forced to set the ODIS ID as the bound column to update the main form
and I don't know how to write the code to force the selection in the reverse
lookup combo box rather than the first Reviewer with the listed Advocate.
-------------------------------
'This is the code I'm using to show the record on the form:

Private Sub reverselookup_AfterUpdate()

' Find the record that matches the control.

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ODIS ID] = '" & Me![reverselookup] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

End Sub

 

[NetworkTrade]

First an aside; it seems that: Reviewer selection dictates unique Advocate
which in turn idenitifies multiple Reviewers..... I don't understand the
request for combobox to display the multiple reviewers. But then it is
probably a misunderstanding and not that important. I myself would use a
popup form or subform or something more suitable to displaying multiple
records...

But in any case I believe your fundamental issue now is in regard to
"requery". Look that up in this forum - you will see many q/a around
updating a combobox based on another combobox selection. Essentially in the
'AfterUpdate' event of combobox-1 you will put in a little vb to force the
requery of combobox-2.

hope this helps
--
NTC

NetworkTrade,

You managed to get the relationships right despite all my mubo-jumbo!

I have created the query you suggested and named it "reverselookup". I set
it up as a combo box with the complete list of Reviewer names and a
corresponding text box that displays the name of that reviewer's advocate.
After which I can use the cascade combo boxes to pull up the corresponding
records.
What I want to do is pare this down into a single operation: By choosing
the reviewer name in the "reverselookup" combo I want the cascade combo boxes
to update.

Please let me know if this clarifies my request at all.

--
Thank you for your help!

-The Chump

I can not answer the question in the structure that you ask it.....

It sounds like there is 1:Many for Advocate:Reviewer
...since you say that selecting Advocate filters the Reviewer choices - and
this part you have running ok.

Assumming this relationship structure; selecting Reviewer is able to give a
unique Advocate ID value.

And with that unique Advocate ID value one can of course present all the
Reviewer choices that cross reference to it.

I would create the query (plain vanilla query using query design) that will
present the correct data when a Reviewer is selected on the form; .....then
at least you have the core record source and can decide creatively as to how
best present it whether it be subform/combobox or whatever....



--
NTC

I have a three combo boxes. Two run as a cascade: "Advocate" selection
limits "Reviewer" selection in subform. What I am trying to accomplish
within the third combo box is a "reverse" lookup: By selecting a "Reviewer"
it will pull up the "Advocate" main form. I got this working, however, when
it pulls up the "Advocate" main form it pulls only the first "Reviewer"
listed under the advocate rather than the selected name.

Where: ODIS ID = Advocate ID, User ID = Reviewer

Here is the SQL query, "reverselookup", I'm using:

SELECT [FR Data].[First Name]+' '+[FR Data].[Last Name] AS Expr1, [FRA
Data].[ODIS ID], [FR Data].[User ID]
FROM [FRA Data] INNER JOIN [FR Data] ON [FRA Data].[ODIS ID]=[FR Data].[FRA
ID]
ORDER BY [FR Data].[First Name]+' '+[FR Data].[Last Name];
-------------------------------
I'm forced to set the ODIS ID as the bound column to update the main form
and I don't know how to write the code to force the selection in the reverse
lookup combo box rather than the first Reviewer with the listed Advocate.
-------------------------------
'This is the code I'm using to show the record on the form:

Private Sub reverselookup_AfterUpdate()

' Find the record that matches the control.

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ODIS ID] = '" & Me![reverselookup] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

End Sub

 

[excel/access-chump]

Thank you for your quick response! I'll give it a shot and see what I come
up with... Don't be suprised if I come back with a few more questions and a
need for more help.
--
Thank you for your help!

-The Chump

First an aside; it seems that: Reviewer selection dictates unique Advocate
which in turn idenitifies multiple Reviewers..... I don't understand the
request for combobox to display the multiple reviewers. But then it is
probably a misunderstanding and not that important. I myself would use a
popup form or subform or something more suitable to displaying multiple
records...

But in any case I believe your fundamental issue now is in regard to
"requery". Look that up in this forum - you will see many q/a around
updating a combobox based on another combobox selection. Essentially in the
'AfterUpdate' event of combobox-1 you will put in a little vb to force the
requery of combobox-2.

hope this helps
--
NTC

NetworkTrade,

You managed to get the relationships right despite all my mubo-jumbo!

I have created the query you suggested and named it "reverselookup". I set
it up as a combo box with the complete list of Reviewer names and a
corresponding text box that displays the name of that reviewer's advocate.
After which I can use the cascade combo boxes to pull up the corresponding
records.
What I want to do is pare this down into a single operation: By choosing
the reviewer name in the "reverselookup" combo I want the cascade combo boxes
to update.

Please let me know if this clarifies my request at all.

--
Thank you for your help!

-The Chump

I can not answer the question in the structure that you ask it.....

It sounds like there is 1:Many for Advocate:Reviewer
...since you say that selecting Advocate filters the Reviewer choices - and
this part you have running ok.

Assumming this relationship structure; selecting Reviewer is able to give a
unique Advocate ID value.

And with that unique Advocate ID value one can of course present all the
Reviewer choices that cross reference to it.

I would create the query (plain vanilla query using query design) that will
present the correct data when a Reviewer is selected on the form; .....then
at least you have the core record source and can decide creatively as to how
best present it whether it be subform/combobox or whatever....



--
NTC


:

I have a three combo boxes. Two run as a cascade: "Advocate" selection
limits "Reviewer" selection in subform. What I am trying to accomplish
within the third combo box is a "reverse" lookup: By selecting a "Reviewer"
it will pull up the "Advocate" main form. I got this working, however, when
it pulls up the "Advocate" main form it pulls only the first "Reviewer"
listed under the advocate rather than the selected name.

Where: ODIS ID = Advocate ID, User ID = Reviewer

Here is the SQL query, "reverselookup", I'm using:

SELECT [FR Data].[First Name]+' '+[FR Data].[Last Name] AS Expr1, [FRA
Data].[ODIS ID], [FR Data].[User ID]
FROM [FRA Data] INNER JOIN [FR Data] ON [FRA Data].[ODIS ID]=[FR Data].[FRA
ID]
ORDER BY [FR Data].[First Name]+' '+[FR Data].[Last Name];
-------------------------------
I'm forced to set the ODIS ID as the bound column to update the main form
and I don't know how to write the code to force the selection in the reverse
lookup combo box rather than the first Reviewer with the listed Advocate.
-------------------------------
'This is the code I'm using to show the record on the form:

Private Sub reverselookup_AfterUpdate()

' Find the record that matches the control.

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ODIS ID] = '" & Me![reverselookup] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

End Sub

 

[excel/access-chump]

OK, I think I might be able to explain it now. I looked at all the posts
listed fro a "requery" search and came up with nothing helpful...
However, I think I can better clarify what I want to accomplish:

1:Many = Advocate:Reviewer

combo box1="Advocate" selection on form shows advocate record and limits
combo box "Reviewer" selection on subform
combo box2="Reviewer" selection on subform shows reviewer record

The best way I can think to explain what I need is to give an example of its
use:
My manager receives a notice regarding a "reviewer" and needs to find their
advocate to inform them of issue:

1- He doesn't want to search through each Advocate selection (box1) and
then search the limited Reviewer selection (box2) until he spots the reviewer
name he's looking for.

2- He wants a list of all the Reviewer names (box3 ?) that, upon slection,
will pull up their Advocate's record (in the primary form) and their record
(in the subform) in one selection.

I don't want to update the available selections in (box1) and (box2), I want
to choose the selections based on (box3).

Please figure out what I am trying to say, I don't know how to say it!!
--
Thank you for your help!

-The Chump

First an aside; it seems that: Reviewer selection dictates unique Advocate
which in turn idenitifies multiple Reviewers..... I don't understand the
request for combobox to display the multiple reviewers. But then it is
probably a misunderstanding and not that important. I myself would use a
popup form or subform or something more suitable to displaying multiple
records...

But in any case I believe your fundamental issue now is in regard to
"requery". Look that up in this forum - you will see many q/a around
updating a combobox based on another combobox selection. Essentially in the
'AfterUpdate' event of combobox-1 you will put in a little vb to force the
requery of combobox-2.

hope this helps
--
NTC

NetworkTrade,

You managed to get the relationships right despite all my mubo-jumbo!

I have created the query you suggested and named it "reverselookup". I set
it up as a combo box with the complete list of Reviewer names and a
corresponding text box that displays the name of that reviewer's advocate.
After which I can use the cascade combo boxes to pull up the corresponding
records.
What I want to do is pare this down into a single operation: By choosing
the reviewer name in the "reverselookup" combo I want the cascade combo boxes
to update.

Please let me know if this clarifies my request at all.

--
Thank you for your help!

-The Chump

I can not answer the question in the structure that you ask it.....

It sounds like there is 1:Many for Advocate:Reviewer
...since you say that selecting Advocate filters the Reviewer choices - and
this part you have running ok.

Assumming this relationship structure; selecting Reviewer is able to give a
unique Advocate ID value.

And with that unique Advocate ID value one can of course present all the
Reviewer choices that cross reference to it.

I would create the query (plain vanilla query using query design) that will
present the correct data when a Reviewer is selected on the form; .....then
at least you have the core record source and can decide creatively as to how
best present it whether it be subform/combobox or whatever....



--
NTC


:

I have a three combo boxes. Two run as a cascade: "Advocate" selection
limits "Reviewer" selection in subform. What I am trying to accomplish
within the third combo box is a "reverse" lookup: By selecting a "Reviewer"
it will pull up the "Advocate" main form. I got this working, however, when
it pulls up the "Advocate" main form it pulls only the first "Reviewer"
listed under the advocate rather than the selected name.

Where: ODIS ID = Advocate ID, User ID = Reviewer

Here is the SQL query, "reverselookup", I'm using:

SELECT [FR Data].[First Name]+' '+[FR Data].[Last Name] AS Expr1, [FRA
Data].[ODIS ID], [FR Data].[User ID]
FROM [FRA Data] INNER JOIN [FR Data] ON [FRA Data].[ODIS ID]=[FR Data].[FRA
ID]
ORDER BY [FR Data].[First Name]+' '+[FR Data].[Last Name];
-------------------------------
I'm forced to set the ODIS ID as the bound column to update the main form
and I don't know how to write the code to force the selection in the reverse
lookup combo box rather than the first Reviewer with the listed Advocate.
-------------------------------
'This is the code I'm using to show the record on the form:

Private Sub reverselookup_AfterUpdate()

' Find the record that matches the control.

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ODIS ID] = '" & Me![reverselookup] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

End Sub

 

[NetworkTrade]

I think you are there.

I wouldn't try to put both regular look up and reverse look up on the same
form using the same comboboxes. Or if it is going to be the same form I
definitely wouldn't use the same comboboxes....I would have 2 combos for
regular look up and 2 for reverse....just for sanity at this stage...

So in the reverse you have ComboBoxReviewersReverse....they make a
selection: : this selection is used as the criteria for that vanilla query
you made that returns the proper Advocate.

ComboBoxAdvocateReverse is sourced on that query.

In the ComboBoxReviewersReverse 'AfterUpdate' Event you put in your vb:
me.comboboxAdvocateReverse.requery

--
NTC

OK, I think I might be able to explain it now. I looked at all the posts
listed fro a "requery" search and came up with nothing helpful...
However, I think I can better clarify what I want to accomplish:

1:Many = Advocate:Reviewer

combo box1="Advocate" selection on form shows advocate record and limits
combo box "Reviewer" selection on subform
combo box2="Reviewer" selection on subform shows reviewer record

The best way I can think to explain what I need is to give an example of its
use:
My manager receives a notice regarding a "reviewer" and needs to find their
advocate to inform them of issue:

1- He doesn't want to search through each Advocate selection (box1) and
then search the limited Reviewer selection (box2) until he spots the reviewer
name he's looking for.

2- He wants a list of all the Reviewer names (box3 ?) that, upon slection,
will pull up their Advocate's record (in the primary form) and their record
(in the subform) in one selection.

I don't want to update the available selections in (box1) and (box2), I want
to choose the selections based on (box3).

Please figure out what I am trying to say, I don't know how to say it!!
--
Thank you for your help!

-The Chump

First an aside; it seems that: Reviewer selection dictates unique Advocate
which in turn idenitifies multiple Reviewers..... I don't understand the
request for combobox to display the multiple reviewers. But then it is
probably a misunderstanding and not that important. I myself would use a
popup form or subform or something more suitable to displaying multiple
records...

But in any case I believe your fundamental issue now is in regard to
"requery". Look that up in this forum - you will see many q/a around
updating a combobox based on another combobox selection. Essentially in the
'AfterUpdate' event of combobox-1 you will put in a little vb to force the
requery of combobox-2.

hope this helps
--
NTC

NetworkTrade,

You managed to get the relationships right despite all my mubo-jumbo!

I have created the query you suggested and named it "reverselookup". I set
it up as a combo box with the complete list of Reviewer names and a
corresponding text box that displays the name of that reviewer's advocate.
After which I can use the cascade combo boxes to pull up the corresponding
records.
What I want to do is pare this down into a single operation: By choosing
the reviewer name in the "reverselookup" combo I want the cascade combo boxes
to update.

Please let me know if this clarifies my request at all.

--
Thank you for your help!

-The Chump


:

I can not answer the question in the structure that you ask it.....

It sounds like there is 1:Many for Advocate:Reviewer
...since you say that selecting Advocate filters the Reviewer choices - and
this part you have running ok.

Assumming this relationship structure; selecting Reviewer is able to give a
unique Advocate ID value.

And with that unique Advocate ID value one can of course present all the
Reviewer choices that cross reference to it.

I would create the query (plain vanilla query using query design) that will
present the correct data when a Reviewer is selected on the form; .....then
at least you have the core record source and can decide creatively as to how
best present it whether it be subform/combobox or whatever....



--
NTC


:

I have a three combo boxes. Two run as a cascade: "Advocate" selection
limits "Reviewer" selection in subform. What I am trying to accomplish
within the third combo box is a "reverse" lookup: By selecting a "Reviewer"
it will pull up the "Advocate" main form. I got this working, however, when
it pulls up the "Advocate" main form it pulls only the first "Reviewer"
listed under the advocate rather than the selected name.

Where: ODIS ID = Advocate ID, User ID = Reviewer

Here is the SQL query, "reverselookup", I'm using:

SELECT [FR Data].[First Name]+' '+[FR Data].[Last Name] AS Expr1, [FRA
Data].[ODIS ID], [FR Data].[User ID]
FROM [FRA Data] INNER JOIN [FR Data] ON [FRA Data].[ODIS ID]=[FR Data].[FRA
ID]
ORDER BY [FR Data].[First Name]+' '+[FR Data].[Last Name];
-------------------------------
I'm forced to set the ODIS ID as the bound column to update the main form
and I don't know how to write the code to force the selection in the reverse
lookup combo box rather than the first Reviewer with the listed Advocate.
-------------------------------
'This is the code I'm using to show the record on the form:

Private Sub reverselookup_AfterUpdate()

' Find the record that matches the control.

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ODIS ID] = '" & Me![reverselookup] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

End Sub

 

[excel/access-chump]

NetworkTrade,
Thank you for your patience and help! With your suggestions and assistance
I think I have it working now. I may be back with some questions on
organizing my query (at the moment I think it may be quite cumbersome).
You've been a great help to me!
--
Thank you for your help!

-The Chump

I think you are there.

I wouldn't try to put both regular look up and reverse look up on the same
form using the same comboboxes. Or if it is going to be the same form I
definitely wouldn't use the same comboboxes....I would have 2 combos for
regular look up and 2 for reverse....just for sanity at this stage...

So in the reverse you have ComboBoxReviewersReverse....they make a
selection: : this selection is used as the criteria for that vanilla query
you made that returns the proper Advocate.

ComboBoxAdvocateReverse is sourced on that query.

In the ComboBoxReviewersReverse 'AfterUpdate' Event you put in your vb:
me.comboboxAdvocateReverse.requery

--
NTC

OK, I think I might be able to explain it now. I looked at all the posts
listed fro a "requery" search and came up with nothing helpful...
However, I think I can better clarify what I want to accomplish:

1:Many = Advocate:Reviewer

combo box1="Advocate" selection on form shows advocate record and limits
combo box "Reviewer" selection on subform
combo box2="Reviewer" selection on subform shows reviewer record

The best way I can think to explain what I need is to give an example of its
use:
My manager receives a notice regarding a "reviewer" and needs to find their
advocate to inform them of issue:

1- He doesn't want to search through each Advocate selection (box1) and
then search the limited Reviewer selection (box2) until he spots the reviewer
name he's looking for.

2- He wants a list of all the Reviewer names (box3 ?) that, upon slection,
will pull up their Advocate's record (in the primary form) and their record
(in the subform) in one selection.

I don't want to update the available selections in (box1) and (box2), I want
to choose the selections based on (box3).

Please figure out what I am trying to say, I don't know how to say it!!
--
Thank you for your help!

-The Chump

First an aside; it seems that: Reviewer selection dictates unique Advocate
which in turn idenitifies multiple Reviewers..... I don't understand the
request for combobox to display the multiple reviewers. But then it is
probably a misunderstanding and not that important. I myself would use a
popup form or subform or something more suitable to displaying multiple
records...

But in any case I believe your fundamental issue now is in regard to
"requery". Look that up in this forum - you will see many q/a around
updating a combobox based on another combobox selection. Essentially in the
'AfterUpdate' event of combobox-1 you will put in a little vb to force the
requery of combobox-2.

hope this helps
--
NTC


:

NetworkTrade,

You managed to get the relationships right despite all my mubo-jumbo!

I have created the query you suggested and named it "reverselookup". I set
it up as a combo box with the complete list of Reviewer names and a
corresponding text box that displays the name of that reviewer's advocate.
After which I can use the cascade combo boxes to pull up the corresponding
records.
What I want to do is pare this down into a single operation: By choosing
the reviewer name in the "reverselookup" combo I want the cascade combo boxes
to update.

Please let me know if this clarifies my request at all.

--
Thank you for your help!

-The Chump


:

I can not answer the question in the structure that you ask it.....

It sounds like there is 1:Many for Advocate:Reviewer
...since you say that selecting Advocate filters the Reviewer choices - and
this part you have running ok.

Assumming this relationship structure; selecting Reviewer is able to give a
unique Advocate ID value.

And with that unique Advocate ID value one can of course present all the
Reviewer choices that cross reference to it.

I would create the query (plain vanilla query using query design) that will
present the correct data when a Reviewer is selected on the form; .....then
at least you have the core record source and can decide creatively as to how
best present it whether it be subform/combobox or whatever....



--
NTC


:

I have a three combo boxes. Two run as a cascade: "Advocate" selection
limits "Reviewer" selection in subform. What I am trying to accomplish
within the third combo box is a "reverse" lookup: By selecting a "Reviewer"
it will pull up the "Advocate" main form. I got this working, however, when
it pulls up the "Advocate" main form it pulls only the first "Reviewer"
listed under the advocate rather than the selected name.

Where: ODIS ID = Advocate ID, User ID = Reviewer

Here is the SQL query, "reverselookup", I'm using:

SELECT [FR Data].[First Name]+' '+[FR Data].[Last Name] AS Expr1, [FRA
Data].[ODIS ID], [FR Data].[User ID]
FROM [FRA Data] INNER JOIN [FR Data] ON [FRA Data].[ODIS ID]=[FR Data].[FRA
ID]
ORDER BY [FR Data].[First Name]+' '+[FR Data].[Last Name];
-------------------------------
I'm forced to set the ODIS ID as the bound column to update the main form
and I don't know how to write the code to force the selection in the reverse
lookup combo box rather than the first Reviewer with the listed Advocate.
-------------------------------
'This is the code I'm using to show the record on the form:

Private Sub reverselookup_AfterUpdate()

' Find the record that matches the control.

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ODIS ID] = '" & Me![reverselookup] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

End Sub