Using a combo (value list) to open a form and use variable to insert value to a field

[carlchapman]

Hi, I have a chase system that i want to integreat into my db. On the chase form you put in fields, on the combo fields i want a action performd. So after update IF ME.combo Value == value1 do this. By this i want it to open up the form according to the value selected (Would a subform be good for this?). Any way their are 5 possible values in my combo. 2 Of them if selectd, i want to open the relating form ( or a subform). To give you more of an insight. If value one selected, open form value1addform. This form i would prefer, if instead of After update was on a command button, so i can come back at a later stage and add the record when i have the data i need to insert. Now, when this form loads, i a record will be created the is within a relationship with the parent form (table). Because of this i need the parent table primary key auto inserted (copied) to value1addform foreign key field, so later queries can be performd.

This is the simplest way to my solution i think. If any 1 can add input as to how to A) use value from combo list to set a global variable to use with a command button (which is only visible after update of combo box if value is that of the value to open a form) B) to use the global variable to insert into a field on form 2.

I do not no much about VBA with regards to global varibles, defining and using them, but any help would be great.