Removing particular data from drop down menu

[krisp]

Hi
New to the boards.
The database i have created needs data removing from it when certain criteria arent met. Basically, when the form is filled in and the person is under 25 i need one range of data to be removed from another table leaving the ranges available to that person. how would i initiate this?
any pointers or links to where i can find this out (anything, i am desperate!!! ) would be appreciated

Thanks

 

[gromit]

Hi - Welcome!

Do you need to restrict the choices of data in a drop down combo box? Or do you need to actually go modify a second table?

For the first, searching the web for "cascading combo boxes". This is usually used when one combo box affects the choices in another combo box. But you could probably modify it for a text box or other field.

If you really need to go modify a table, then you need to write some VBA code to manipulate the table directly.

I think if I am understanding correctly, that you should be able to use the combo box to restrict data to accomplish this.

hope that helps,

- g