 | |
Re: Refreshing a combo list
comp.database.ms-access comp.database.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Refreshing a combo list -
09-03-2003
, 05:21 PM
|
I wonder if anyone would be kind enough to offer some advice. I have limited experience of using Access but wish to use it to keep track of some comic books that I plan to sell. I've based the database around the NWIND example but I've hit a snag trying to get it to do something clever. When I run the Order form, there is a sub form - "Orders Subform" - which has a field for selecting the comic book title that I have "sold" and a Yes/No field for whether it is sold. The comic book is selected from a combo box that uses a query as its source. This query is set to display just those comics that have not been sold. What I want it to do is once I ticked the sold field on the sub form, have that change reflected in the list that is displayed the next time I select from the combo box (i.e. not to list the comic I've just ticked). This works fine if the form is closed and then re-opened but not if you just move to the next record. I probably need to force an update/requery at some point but I'm at a loss to know where? Many thanks, hope its not too much of a frivolous request. Jeff Barry, Manchester, England |
Me![MyComboBox].Requery
or if calling from another form/subform
Forms!MyForm![MyComboBox].Requery
Hope that helps.
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/reponse
#2
| |||
| |||
|
|
"Jeff Barry" <jbarry (AT) picr (DOT) man.ac.uk> wrote in message news:b829cad8.0309030734.b1f8d7b (AT) posting (DOT) google.com... I wonder if anyone would be kind enough to offer some advice. I have limited experience of using Access but wish to use it to keep track of some comic books that I plan to sell. I've based the database around the NWIND example but I've hit a snag trying to get it to do something clever. When I run the Order form, there is a sub form - "Orders Subform" - which has a field for selecting the comic book title that I have "sold" and a Yes/No field for whether it is sold. The comic book is selected from a combo box that uses a query as its source. This query is set to display just those comics that have not been sold. What I want it to do is once I ticked the sold field on the sub form, have that change reflected in the list that is displayed the next time I select from the combo box (i.e. not to list the comic I've just ticked). This works fine if the form is closed and then re-opened but not if you just move to the next record. I probably need to force an update/requery at some point but I'm at a loss to know where? Many thanks, hope its not too much of a frivolous request. Jeff Barry, Manchester, England Try.. Me![MyComboBox].Requery or if calling from another form/subform Forms!MyForm![MyComboBox].Requery Hope that helps. |
thing about databases, from my point of view, is the temptation to
keep trying to refine it whilst not really having a full understanding
of how all the bits connect with each other.
Cheers
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.