Update Query - writing a value into a blank field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I'm using a Form to enter data into a predefined Data Table. I'm using
Combo Boxes pointing to a Table from which the user can make one of 4
selections. Each selection has a preset value field directly adjacent in the
Table. Everything works great with the exception that the only way I can get
the values of the selection to the Form is the use of another Combo Box -
which I don't like.

What I need to do is have the value come foreward to the Form (thereby to
the data table) automatically when the user makes their selection.

The Form as is now configured is pointing to the predefined Data Table with
the Combo Boxes pointing to the Selection Tables

I've tried point the Form to a Query first which linked to the predefince
Data Table and the Selection Table. But that only get me the error message
from the Form that says "Records are not updateable" or something close to
that.

This should be a simple thing to do - I've even done it before but can't
remember how to do it.

Thanks for the help,
Larry
 
Larry,

Perhaps if you could post back with specifics as to tables, fields,
forms etc, and some examples, it may make it easier to understand what
you're doing.
 
Back
Top