By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,461 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

clearing drop down menus in access

P: 27
I have two drop down combo boxes combo27 and combo29 my code in combo27 is this

Expand|Select|Wrap|Line Numbers
  1. Private Sub Combo27_AfterUpdate()
  2. Dim rs As Object
  3. Set rs = Me.Recordset.Clone
  4.     rs.FindFirst "[CompanyID] = " & Str(Nz(Me![Combo27], 0))
  5.     If Not rs.EOF Then Me.Bookmark = rs.Bookmark
  6. End Sub
in my rowsource for combo29 I have

Expand|Select|Wrap|Line Numbers
  1. [Forms]![frmCustomers]![Combo27]

However, when I change my mind on combo27 combo29 isn't changing to my new parameter.

for example if I pick client 1 in combo27 it will give me a test result, but if I go back and click client2 combo29 still stays with client1's results. How do I clear this or reupdate it?
Mar 9 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,349
Put this at the end of that code:
Expand|Select|Wrap|Line Numbers
  1. Me.Combo29.Requery
Mar 9 '07 #2

P: 27
Thankyou so much for your help, it works great now.
Mar 9 '07 #3

Rabbit
Expert Mod 10K+
P: 12,349
Not a problem, good luck.
Mar 9 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.