If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Combo Boxes
I am afraid I had already done this and nothing seems to happen.
Am I able to email you the mdb to have a look at? Andrew Rick Brandt wrote: Andrew wrote: Ok, I have created code for the form as follows Option Compare Database Private Sub Form_Current() Me!Finishes.Requery End Sub Private Sub VenRange_AfterUpdate() Me!Finishes.Requery End Sub Finishes is the name of combo box2 VenRange is the name of combo box1 This does not appear to be working. I still have to press f9 to refresh the combobox2 Am I being dense? It is not enough to write the code. You also have to set the Event Properties to [Event Procedure]. That is what causes the code to be run at the appropriate times. Right now your code is just sitting there never being called. In form design view bring up the properties sheet and click on the Events tab. In the On Current property box of the form enter [Event Procedure]. Do the same in the After Update property of the VenRange control. Then it should work. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#12
|
|||
|
|||
Combo Boxes
Andrew wrote:
I am afraid I had already done this and nothing seems to happen. Am I able to email you the mdb to have a look at? You'll have to zip it or change the file extension. My Email server will not allow MDB file attachments. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#13
|
|||
|
|||
Combo Boxes
I emailed and got a delivery failure....
bay0-mc1-f15.bay0.hotmail.com #5.5.0 smtp;550 Requested action not taken: mailbox unavailable (-790574797:1382:-2147467259) Andrew Rick Brandt wrote: Andrew wrote: I am afraid I had already done this and nothing seems to happen. Am I able to email you the mdb to have a look at? You'll have to zip it or change the file extension. My Email server will not allow MDB file attachments. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#14
|
|||
|
|||
Combo Boxes
Andrew wrote:
I emailed and got a delivery failure.... bay0-mc1-f15.bay0.hotmail.com #5.5.0 smtp;550 Requested action not taken: mailbox unavailable (-790574797:1382:-2147467259) You have to use the masked Email in my signature. The Email address that would come up automatically is a dummy (sign of the times I'm afraid). -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#15
|
|||
|
|||
Combo Boxes
Ok, thank you. I have done that.
Andrew Rick Brandt wrote: Andrew wrote: I emailed and got a delivery failure.... bay0-mc1-f15.bay0.hotmail.com #5.5.0 smtp;550 Requested action not taken: mailbox unavailable (-790574797:1382:-2147467259) You have to use the masked Email in my signature. The Email address that would come up automatically is a dummy (sign of the times I'm afraid). -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#16
|
|||
|
|||
Combo Boxes
Andrew wrote:
Ok, thank you. I have done that. Your query you are using for the RowSource of the Finishes ComboBox is not correct. First it includes the OrdersItems table (with no join) and it should not (delete that). Second the criteria that should be pointing to the VenRange ComboBox was... [OrderItems]![BRange] ....and it needs to be... [Forms]![OrderWoodVen]![OrderWoodVenItems].[Form]![VenRange] I will return a corrected file, but in case there are problems with that you should be able to make the changes described and it will work. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
|
Thread Tools | |
Display Modes | |
|
|