Drop-down paramter management

[PaulA]

Hi, all--

I have forms that have multiple control boxes where the value of one control box will determine the values of the drop-down list in the next control box. I did this with a parameter query as the row source for the second query. In order for the values of the list to change each time the first control box was updated, I have a "me.refresh" event procedure for "after update."

Now I am getting into more complex things like refrential integrity and the refreshing now causes error messages.

Is there a better way to do this?

Thanks.

 

[wizcow]

PaulA

What kind of error messages?
What your doing should work.

Tom

 

[PaulA]

Generally two types, based on table properities--

If a "required" property is yes on a field that has not yet been entered (a later field), the refreshing seems to establish a record and I get a "null value" message.

The other is based on referential integrity--if a value is enterred in the first drop-down box and there is no corresponding values for the second, the message says that there must be corresponding records in the second table.

I also get an untime error sending me to the code line "refresh"

Thanks for your input.

 

[Rich]

Me.Refresh is forcing a save operation, Requery the second combo on the AfterUpdate of the first and so on