So I have a box in access, in this box I am linking it to a list box which
runs a query and populates the text box with a field from a table. What I
want is the user to then be able to type into the box and enter a field to
the table, replacing the field current being shown, or to enter a new field
into the table on a new row. The trouble I am having is that I can not seem
to figure out how to make it take a typed in value. I assume a on enter or
after update event would do, but it doesn't seem to like it when I tried
tossing a update parameter query into the events there (directly into the
dialogue box) so now I'm wondering if I need to be using Vb to do this, or
better yet, how I can use vb (that way i can store changes into a vb var and
then give the user a 'are you sure' prompt before updating.

Any help would be appreciated.