updating issues on form

[JoeSmoe55]

Hello all,

I want to fill the contents of a form based upon the values of the two key fields. I populate the items of the first key field(combo box) and once the user chooses a value, I populate the second, also a combo box. If they choose one of the pre-existing values, I get warnings because of data integrity because at this point it is no longer an add but an update. if I change the dataentry value, if trys to save the record and I get other integrity problems because a number of fields have not been filled in. Is there a way to do this without making another form. To restate, The user will be able to edit pre-existing records by choosing the values from combo boxes Or they can type the new values into the combo box. If they choose a pre-exising record keys, then it will load the corresponding record(this part works). Is there a way to suppress the errors or switch between adding and updating a record without access trying to save the record?

Thanks in advance,
Joe

 

[CautionMP]

DoCmd.SetWarnings [blue]False[/blue]

JoeSmoe55: having problems updating&inserting on form

Instant programmer, just add coffee.

 

[TheAceMan1]

How are ya JoeSmoe55 . . .

The comboboxes should be [purple]unbound![/purple] Code validating both combo's should then instantiate your record fill needs . . .

See Ya! . . . . . .