Immediately update table with form?

[Rosier75]

I have a database that contains data for multiple users. I have created forms that allow users to search the database based on specific criteria and update records in the associated table (via a command button) if need be. Is there a way to have records in a table update immediately after making updates in the form? I currently accomplish my updates by using a different append/update queries. I'm thinking there has to be an easier way.

Can anyone help with this?



Thanks

[Missinglinq]

By simple way is by using Access as it was intended to be used, with Bound Forms! When a Form is Bound, the Record is committed to the Table, automatically, as soon as the user moves to another Record, closes the Form or closes Access itself.

Don't know why you're apparently using Unbound Forms, here. The usual justification for this is the belief that Unbound Forms are necessary in order to do data validation before "committing" data to a Table, and this is simply not true!

Any "checks" you need to do before saving the data can be done using the Form_BeforeUpdate event of a bound form and Cancel = True to stop the saving of the record until missing/erroneous data is dealt with!

A big part of the reason to use Access for database development is the speed with which it can be created, using Bound Forms. Several developers I know, experienced in both Visual Basic database development and Access development, estimate that development using Unbound Forms by experienced developers takes two to three times as long as it does when using Access and Bound Forms.

If you insist on using unbound forms, you'd be far better off using a straight VB or C++ front end with a SQL Server or Oracle back end.

• You can create an EXE file which gives total protection to your code/design
• You can distribute the db to PCs without a copy of Access being on board
• Your data security is far, far better than anything you can do in Access

Linq ;0)>

[Rosier75]

Thanks for the quick reply. The form I am referencing is bound to a specific table. It is true that the when the form fields are updated, the table itself will be updated when the user cycles to an additional record or closes the form. What I am trying to determine is if there is a way to automatically and/or immediately commit the value/text inputted in the form field to the bound table without moving to the next record? This step is important to the overall use and intent of the database.

Thanks

[Missinglinq]

I cannot , in my wildest dreams, imagine how committing a Record, each time a single Field is changed, could be "...important to the overall use and intent of the database," but you can force an immediate Save by using the line

DoCmd.RunCommand acCmdSaveRecord

in the AfterUpdate event of each Control whose Value you want to Save immediately.

Linq ;0)>

[ssanfu]

I too am curious about "...important to the overall use and intent of the database,..."

To force a save, in the AfterUpdate event, I would use:

Me.Dirty = FALSE

RunCommand (IIRC) has been depreciated.

[Missinglinq]

As my old signature used to say, "There's always more than one way to skin a cat!"

RunCommand is alive and well, but if you prefer to use

Me.Dirty = FALSE

you should get used to testing if the Form is Dirty first, using

If Me.Dirty Then Me.Dirty = FALSE

as there are conditions (sorry, I can't remember exactly what conditions, off hand) that will pop an error if the former is used and the Form is not Dirty.

DoCmd.RunCommand acCmdSaveRecord, on the other hand, won't pop the error.

BTW, the Boys of Redmond would have us believe that VBA Code and Event Procedures are depreciated, also, in favor of Embedded Macros, but we know better than that, don't we? It's all a matter of personal preference! And, in point of fact, I usually use

If Me.Dirty Then Me.Dirty = FALSE

myself!

Linq ;0)>

[ssanfu]

I have seen

Me.Dirty = FALSE

but never tried it in without the IF test. The form I do use is

If Me.Dirty Then
Me.Dirty = FALSE
End IF


RE VBA Code/Event Procedures/Macros .......