Requery Combo box

[Nick]

I am using a combo box to issue member number to new
members. The list of available number for the look-up
comes from a query. When I use the dropdown list in the
query I use the After update event procedure to use the
following;
Private Sub No_AfterUpdate()
Me![No].Requery
Me![Fees-sub New Members].Requery
Me![frmDuplicate_Member_No_Chech].Requery

End Sub

How do I get the dropdown list to update after selecting a
number? It updates when I close and reopen the form.

All help appreciated

Nick

 

[Guest]

Hi

Not totally sure I understand the question but the
OnChange event occurs before the OnUpdate event. That
might be useful.

Cheers

David Cleave

 

[Nick]

In my club we are limited to 1000 members. When a member
leaves we can re-issue that number. I issue the number
from a combo box, which gives me a list of un-used number.
After I have selected the number from the list I need to
up-date the list so that I don’t issue the same number
twice.
Any suggestions on how to re-query the combo box list

Regards
Nick

-----Original Message-----
Hi

Not totally sure I understand the question but the
OnChange event occurs before the OnUpdate event. That
might be useful.

Cheers

David Cleave

-----Original Message-----
I am using a combo box to issue member number to new
members. The list of available number for the look-up
comes from a query. When I use the dropdown list in the
query I use the After update event procedure to use the
following;
Private Sub No_AfterUpdate()
Me![No].Requery
Me![Fees-sub New Members].Requery
Me![frmDuplicate_Member_No_Chech].Requery

End Sub

How do I get the dropdown list to update after selecting a
number? It updates when I close and reopen the form.

All help appreciated

Nick
.

.

 

[John Spencer (MVP)]

Perhaps you can use the OnCurrent Event of the form?

Me.[No].Requery

Of course, I would have a better name for the combobox than "No". I would
probably name it something like cboxMemberNo.

Also, to ensure that a number is not used more than one time, I would have an
index on the "No" field that would not allow duplicates. That way you couldn't
ever get a duplicate value in the field - a wrong value, sure, but a duplicate
no. And wrong values might be controllable by using the right input mask or the
right validation rule. That, of course depends on the construction of the
values in the "no" field.

In my club we are limited to 1000 members. When a member
leaves we can re-issue that number. I issue the number
from a combo box, which gives me a list of un-used number.
After I have selected the number from the list I need to
up-date the list so that I don’t issue the same number
twice.
Any suggestions on how to re-query the combo box list

Regards
Nick

-----Original Message-----
Hi

Not totally sure I understand the question but the
OnChange event occurs before the OnUpdate event. That
might be useful.

Cheers

David Cleave

-----Original Message-----
I am using a combo box to issue member number to new
members. The list of available number for the look-up
comes from a query. When I use the dropdown list in the
query I use the After update event procedure to use the
following;
Private Sub No_AfterUpdate()
Me![No].Requery
Me![Fees-sub New Members].Requery
Me![frmDuplicate_Member_No_Chech].Requery

End Sub

How do I get the dropdown list to update after selecting a
number? It updates when I close and reopen the form.

All help appreciated

Nick
.

.