cascading combo boxes and required fields.

[Homegrownandy]

I have made a form with cascading combo boxes. For these to work properly the form needs to requery on change event of the combo box. (it needs to wipe anything relating to that combo box, so the user cant enter incorrect information.)

The problem is, most of the fields are required fields, so the form has various errors depending what I do. Most recently I get the Error 3314 value must be entered.

Its trying to complete the record I'm half way through because of the requery. I'm a bit stumped. appreciate any ideas, Thanks.

[Homegrownandy]

suppose I could remember values for later use then append.

[Micron]

Some of the explanation is a bit vague, but maybe a refresh would work instead of requery?
Depending on the process, sometimes a temp table works better. Validation can be done when the attempt is made to 'move' the temp record to the permanent table.

[Homegrownandy]

Some good advice there. Didn't even think of a temp table. Also a refresh is what I should have been doing not a requery. thanks.

[orange]

Andy,
You might also consider TempVars.
Good luck