Forum Moderators: open
I'm building a fairly straightfoward form to be the user interface for people to report the need for maintenance in their offices. They want the date and time the request is made to be automatically filled in.
Is there a way to have that information populate form fields? I can do Insert > Date & Time, which works but which also deletes the field, and there's a push for consistency in appearance (all the other information will be in fields, drop-downs, etc.)
Another concern about using Insert > Date & Time is that the contents of this form will dump to an Access database every night; will the date and time export to a database the same way as the contents of the form fields? Or would they require additional manipulation since they were originally inserted components?
Ideally, I'd like actual form fields to display, and auto-fill the date and time. If Inserted Date & Time will go seamlessly into the database, I might be able to persuade them that the appearance issue is secondary.
Another issue, though, is this: With either method (form fields or inserting), is there a way to "lock" the contents in, so they won't refresh/update every time someone views the document?
I apoloize if this is disjointed - if it is, it's just a reflection of my thought processes at the moment...
