Inserting Data

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

Guest

I have noticed that when I insert the data into a field and then tab out of
the field, it acts differently than if I had actually typed the data into the
field. It does not seem to update.

How can I make JUST the field update and not the entire record. The reason I
want just the field is because sometimes I have code running in BeforeUpdate
to make sure all the mandatory fields have been completed before a record is
saved.

Thank you in advance for any responses.

Rick
 
There's no way to just update a single field: the entire row is touched.

Can you provide some details about what's different between when you insert
the data then tab out versus when you type the data?
 
For Example:

Date Field: OrderDate
Command Button: AddRecordButton

When the "Click" function of AddRecordButton is activated, the user goes to
a new record and todays date is inserted into the OrderDate field as a
default date. The focus is then set to that field in case the user wants to
change the date.

On the BeforeUpdate or AfterUpdate [Event Procedure] of the OrderDate field,
if the user just accepts the default/inserted date and tab's out, it does not
seem to determine the following:

Me.CSCallDate = Me.OrderDate + 30

Rick
 
The only way that clicking on a text box should move you to another row is
if you've got code in the Click event to reset focus.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Rick_C said:
For Example:

Date Field: OrderDate
Command Button: AddRecordButton

When the "Click" function of AddRecordButton is activated, the user goes
to
a new record and todays date is inserted into the OrderDate field as a
default date. The focus is then set to that field in case the user wants
to
change the date.

On the BeforeUpdate or AfterUpdate [Event Procedure] of the OrderDate
field,
if the user just accepts the default/inserted date and tab's out, it does
not
seem to determine the following:

Me.CSCallDate = Me.OrderDate + 30

Rick

Douglas J Steele said:
There's no way to just update a single field: the entire row is touched.

Can you provide some details about what's different between when you
insert
the data then tab out versus when you type the data?
Click to expand...
Click to expand...
 
Back
Top