Criteria Drop Down Help

[skilche1]

In form view, I am trying to list product components (from the "Drop Down Box") associated to a particular product. The problem I am having is when I go a new record and select a different product; I get the same components from the last product I had previously inputted. In other words, the components do not change with the product change. Does anyone have any idea what settings I need to change to that the components match that of the associated product in real time?

I have attached the file for your viewing. I also have the form open when file is opened.

Thanks in advance for your help.

 

[ghudson]

Check out the filteredcomboboxes.zip sample I posted.

HTH

 

[skilche1]

Darn

ghudson

I tried your method. However, it does not seem to work with subforms. Any other ideas?

 

[skilche1]

Anyone have ideas?? I really need to close the loop on this one.

Thanks

Steve

 

[SforSoftware]

The most simple way is to run a requery on the combobox in the GotFocus-event. I always do it by putting this function in a standardmodule:

Public Function RequeryControl()
  On Error Resume Next
  Screen.ActiveControl.Requery
End Function

Then in the On-Focus-property of the combobox(es) put: =RequeryControl()

Now every time you'll select the combobox, the data in it will be refreshed.

 

[skilche1]

SforSoftware

Where is the "On-Fucus-property"? I was able to locate "On GotFocus", but have no idea where "on-Focus-property". Where could it be?

Thanks,

Steve

 

[skilche1]

Never mind,

After working it further, I was able to figure it thanks to all for your help. A special thanks to SforSoftware. Have a great holiday weekend.

Steve.

P.S. I love this forum

 

[SforSoftware]

I'm sorry, but I don't work with an English version of Access, so I'm not always sure of the correct names...

Glad I could help you

Greetz,
Bert