update a hidden field on insert in datasheet view

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

Guest

Hi,
I have posted a similar question yesterday, but since i messed up badly
on repling the follow ups, i am better off just to start a new thread, sorry.

I have a form in datasheet view, it was built from a query. it has 3
fields: Item#, Item Name and Qty. Item# is a hidden column - not shown in
the Datasheet (although there is a value - 'cz it's pulled from select query
where clause is the item# - the hidden field). when new records are entered
in the datasheet, Item# on the new records are blank since the user cannot
type in a hidden field. The item# should be same as what's in the query
(where clause) .

How can I make when a new record is entered, update the Item# before the
insert, or how to put that value into the hidden field?

Thanks
 
You could make cz the Default Value of the field. This will place cz in the
field automatically when you go to a new record, but the record won't be
"dirty" until the user also makes a change in another field so it won't
cause records with nothing by cz in them to be saved.
 
Wayne Morgan said:
You could make cz the Default Value of the field. This will place cz in the
field automatically when you go to a new record, but the record won't be
"dirty" until the user also makes a change in another field so it won't
cause records with nothing by cz in them to be saved.
Click to expand...
 
Back
Top