Form Navigation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I posted this question on 12/7 but it was worded wrong and I never got any
replies. My Problem is... I have a form that auto-fills some fields on a
new record when it is opened or after a record is entered. On the table
linked to this form some of the fields that do not auto fill on the form are
required. This is causing an error message when I try to navigate backwards
on my form or try to close the form. It says that the name field is required
on the table and the record cannot be saved at this time. I cannot turn off
the required property of the name field on the table because that poses all
new problems. Is there anything I can do to at least kill that message box
that pops up? I could live with not being able to navigate backwards if I
have to because it will be all inserting new data on this form anyway, but I
really don't want to see that message everytime I close the form. Any ideas
will be greatly appreciated. Thanks in advance.
 
Brent said:
I posted this question on 12/7 but it was worded wrong and I never
got any replies. My Problem is... I have a form that auto-fills
some fields on a new record when it is opened or after a record is
entered. On the table linked to this form some of the fields that do
not auto fill on the form are required. This is causing an error
message when I try to navigate backwards on my form or try to close
the form. It says that the name field is required on the table and
the record cannot be saved at this time. I cannot turn off the
required property of the name field on the table because that poses
all new problems. Is there anything I can do to at least kill that
message box that pops up? I could live with not being able to
navigate backwards if I have to because it will be all inserting new
data on this form anyway, but I really don't want to see that message
everytime I close the form. Any ideas will be greatly appreciated.
Thanks in advance.
Click to expand...

Instead of setting those values on a new record, just set the default value
properties. Then a record is not actually started until the user starts
typing. Simply navigating to a new record and off again will not raise any
errors since the form was never dirtied.
 
Thanks for the response but that will not work with what I am trying to
accomplish. Users that will be using this form will be doing quite a bit of
daily data entry and I need some fields to fill with what was in the last
record, not necessarily a default value though. If I cant pull this off it
will be way too redundant for them to enter some of the same things over and
over and would considerably lengthen the amount of time it would take them to
complete the data entry and make it almost not even worth using. Any other
ideas?
 
Brent said:
Thanks for the response but that will not work with what I am trying
to accomplish. Users that will be using this form will be doing
quite a bit of daily data entry and I need some fields to fill with
what was in the last record, not necessarily a default value though.
If I cant pull this off it will be way too redundant for them to
enter some of the same things over and over and would considerably
lengthen the amount of time it would take them to complete the data
entry and make it almost not even worth using. Any other ideas?
Click to expand...

But you can use code to change the DefaultValue property to whatever you want.
If you're current code "knows" what to set the values to just put those same
values in the DefaultValue property instead.
 
Access does offer a repeat from previous record keyboard
shortcut. When you are entering the data on your
form, use the Ctrl+' keys repeat the same value in a
field as in the previous record.

Chris
 
Back
Top