I have been working on a form which I ended up having to base the
fields off of a query. To make a long story short the top part is
the main form and is bound to a simply query that displays fields in
two tables. Below is several subforms that are bound to a response
table. The top part is currently designed so that I select a person
and the other fields at the top populate. The bottom subforms are
where they select answers to questions and the results are all
stored in a table called response. This all is working except
one thing. Each of the set of questions is in its own subform. I
know I could have designed this different but based on other
feedback I received and trouble I ran into getting this created this
seemed to be the best solution for the way I wanted data entry to
work and also it seems to work so I left it so each question is
built in its own subform. In these sets of subforms maybe the first
10 are based upon one paper form the user has, the next set
of 15 are based on another paper form, and so on.
To make this long story short I need to be able to have the user
type a date somewhere on the form and that date be stored to some
temporay date table or just stored somewhere so that when each
question is answered in the subform,it will use whatever date is
there and post it to the response table with that set of questions.
I have no clue on how to do this. I first tried to create an unbound
text box and format it as a short date but I have no way to know how
I can tell the subforms to link back to whatever is in that field
and post it to the date field in the response table for that set of
questions. I then thought if I could find a way to make it so I type
a date and after focus have it store that date to some table, I may
then be able to find a way to make them use the date in the table
and post it to the response date field. I am just looking for an
easy way to do this without getting into complicated coding. I know
there may be a more efficient way of doing all of this but I have my
entire project completed except implementing the date. Any help is
appreciated.
Thanks,
Dale
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
