update unhidden column of a form in Datasheet view

[Guest]

Hi,
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

 

[Wayne Morgan]

Please don't post separate copies of the same message into multiple
newsgroups. If you believe you must post into more than one group, please
place all groups in the To box so that the same message goes to all of the
groups. This way, when someone replies, the reply also goes to all of the
groups.

Message answered in m.p.a.forms