Set value in non-displayed fields

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

StCyrM

Hi Jonathan

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

Maurice
 
R

Rick Brandt

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

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

Top