J
John F.
Hi:
I have a combobox populated by Column(0) of a table, "DIAGNOSIS LIST" with 2
columns. When I choose an item from the list and move out of the combobox,
the corresponding value in Column(1) of the list is inserted into another
field on the form's underlying table, using the 'AfterUpdate' event of the
combobox.
If I type in a value not on the list, i want to open the form that allows
editing of the "DIAGNOSIS LIST" table; however, I get an error telling me
that Column(1) doesn't exist before the form to do the editing (and add a
value for Column(1) is opened.)
How do I tell that the item in Column(0) does not exist on the list and get
the "DIAGNOSIS LIST" editin form to open BEFORE AfterUpdate tries to do
something with the (non-existent) Column(1)?
Thank you.
johno
I have a combobox populated by Column(0) of a table, "DIAGNOSIS LIST" with 2
columns. When I choose an item from the list and move out of the combobox,
the corresponding value in Column(1) of the list is inserted into another
field on the form's underlying table, using the 'AfterUpdate' event of the
combobox.
If I type in a value not on the list, i want to open the form that allows
editing of the "DIAGNOSIS LIST" table; however, I get an error telling me
that Column(1) doesn't exist before the form to do the editing (and add a
value for Column(1) is opened.)
How do I tell that the item in Column(0) does not exist on the list and get
the "DIAGNOSIS LIST" editin form to open BEFORE AfterUpdate tries to do
something with the (non-existent) Column(1)?
Thank you.
johno