Elementry VBA Update

[BJWink]

This may be a little insulting for some, but I don't know VBA and i'm on a deadline(its difficult enough to try and teach yourself VBA).

Given the table:

Cause of Death(cause_of_death)
(directly related to a fatality table.

On a form, Cause of death is a combo box with about 12 choices (including 'other')

Suppose the user chooses 'other' for cause_of_death. What code would you use that would prompt an update form linked to the Cause Of Death table.

 

[biot023]

Assuming cause_of_death is a string, something like:

if cause_of_death="Other" then
DoCmd.OpenForm "MyUpdateForm"
end if

You'd need ro requery the list at some point as well, if the user can update the table.

Douglas JL If it don't make you laugh, it ain't true.