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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding an empty value 4
Thought you should see this 1
Weird message 5
Show gif while form is "thinking" 9
Problems with OrderBy 3
Leave button pushed in 2
Delete record in subform 1
Hding menu bar 2

Back
Top