Subform Update Problem--Please Help

R

rxponder

I have an Orders Subform Linked to Manufacturer Main Form. Everything
works fine, except... I have 2 fields on the Orders Subform:
"OrderReceived" set to Yes/No check box, and "OrderedReceivedDate" set
as a Date/Time field. I would like the "OrderReceivedDate" field to
populate with Date() when the "OrderReceived" check box is checked.

I've tried all kinds of expressions (IIF statements) in the
BeforeUpdate and other event properties in the "OrderReceivedDate"
properties to no avail. Can some one please help me with either code
or expression, and where to place it to make this seeming simple task
work?

Your help is always greatly appreciated.

Brad
 

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

Top