Need help with forms

[wayne]

I have two questions that I really need help with please.

1. while in a form (form view) I have txt boxes that have controlled
sources. I have data in the table. If I move the scroll roller on my mouse
the boxes will scroll through all the fields from my table. How do I turn
this off?
2. I have a txt box with an expression to give me current date and time. How
can I get the form to automatically write that value to a field in a table
after I initiate a save? currently if I add this to the default, the =Now()
expression will not work.
Thanks

 

[Graham R Seach]

Wayne,

1. See http://www.lebans.com/mousewheelonoff.htm for a utility to help with
the mousewheel issue.

2. If you want today's date to be the default, the best way is to set it in
the table. Open the table in design view, and set the appropriate field's
Default Value as follows (including the = sign):
=Now()
...or...
=Date()

Now() will save the date + time, whereas Date() will just save the date.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia