Combo box update 2

[Bill0722]

I have a farily simple form of customers. I use a combo box to select the record I want by picking the names of customers. I also have a button that allows me to add a new record. However, when I add the record, it seems that I have to exit and re-enter the form to get the list of customer names in the combo box to update. Is there a way to force the list in the box to update.

 

[mhartman1]

Hello:
You want to do a me.requery or refresh in your code after your new record is entered.
'
Search the requery method in your help file or online help.
Regards
Mark

 

[TheAceMan1]

How are ya Bill0722 . . .

[blue]   Me![purple][b]ComboboxName[/b][/purple].Requery[/blue]

See Ya! . . . . . .

 

[Bill0722]

Two rather elementary questions.

First -- what is the significance of the Me! statement

And secondly, is it possible to requerry a Combo box in a primary form from a secondary form.

Thanks a bunch again

 

[Eupher]

Hi, Bill0722,

Me is the VBA form/report self-identifier. It's a short-cut way of referring to the current form or report object in code.

Ken S.

 

[PHV]

In the AfterUpdate event procedure of the subform:
Me.Parent![combo name].Requery

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886