Set value in non-displayed fields

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

Jonathan Blitz

I have fields in a table that do not appear on the form.
How do I set values for these fields so that they will be added correctly to
the database.
I know what values I want to put there.

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
Hi Jonathan

Simply place 2 hidden text boxes on your form and bind them to the appropriate
fields in your table.

Maurice
 
You don't even need the hidden controls. Just set the values of the fields
directly.

Me![EntryDate] = Date()

The above will work if there is a control on your form named "EntryDate"
(bound or unbound), or if there is a field in the table named "EntryDate"
(with or without a control bound to it), or if you have a control bound to
a field and both are named "EntryDate".
 
Back
Top