Unbound form to update continuous form fields (1 Viewer)

Coldsteel · Sep 18, 2012

Hello,

I am trying to update a continuous form with multiple records with a unbound text box. I have tried the following on click event and I am only updating one record on the continuous form.

Here is my on click event vba:

Code:

Private Sub cmdarea_Click()

Area = txtupdate


End Sub

Any help would be appreciated , thanks

Coldsteel · Sep 18, 2012

Here is a copy of my database

Galaxiom · Sep 18, 2012

Only the current record is affected with that code.
Updating multiple records is usually done with a query.

How does your form select those records? You would use the same criteria in the query to control which records are updated in the table.

Coldsteel · Sep 18, 2012

Thanks for the help,

The selection is made from the form Main, you click on the hosting field and it opens the continuous form (Hostveiw) with the matching hosting name , and it is that selection which I want to update

Coldsteel · Sep 18, 2012

I made the following update query with the following sql statement, is this the most efficient way?

UPDATE Inv SET Inv.Area = [Forms]![Hostveiw]![txtupdate]
WHERE (((Inv.Hosting)=[Forms]![Hostveiw]![Hosting]));

Galaxiom · Sep 19, 2012

That is basically it. However you will get prompts when you run the query with DoCmd.OpenQuery

Use the following code and that will be avoided. This code is for numeric values and will need to be modified with the proper delimiters for string or date values.

Code:

 Dim strSQL as String
strSQL = "UPDATE Inv SET Inv.Area =" & [Forms]![Hostveiw]![txtupdate]" _
       & " WHERE Inv.Hosting=" & [Forms]![Hostveiw]![Hosting]
 
CurrentDb.Execute strSQL, dbFailOnError

Pat Hartman · Sep 19, 2012

If you have to update multiple records this way, the table is not correctly defined. The Hosting field belongs in a higher level table.

Galaxiom · Sep 19, 2012

Pat Hartman said:
If you have to update multiple records this way, the table is not correctly defined. The Hosting field belongs in a higher level table.

That may well be the case Pat, but with due respect, you really know nothng of the poster's data structure or reason for this update so it is quite inappropriate for you to make that judgement.

I can think of valid cases where such an update could be required in a normalised structure.

Looking at another post you seem to be in a very judgemental mood today.

Pat Hartman · Sep 20, 2012

you really know nothng of the poster's data structure or reason for this update so it is quite inappropriate for you to make that judgement

And your statement isn't judgemental? Did you look at the database?

Galaxiom · Sep 20, 2012

Pat Hartman said:
And your statement isn't judgemental? Did you look at the database?

Yes I have had a look at the database sample provided. There is not enough information there to determine the nature of relationships in any real data.

By your judgement I expect you have assumed that Hosting and Area are directly related but this cannot be presumed.

My comment stands.

So you are now being judgemental about my judgment of your judgmentalism?

Unbound form to update continuous form fields (1 Viewer)

Coldsteel

Registered User.

Coldsteel

Registered User.

Attachments

Galaxiom

Super Moderator

Coldsteel

Registered User.

Coldsteel

Registered User.

Galaxiom

Super Moderator

Pat Hartman

Super Moderator

Galaxiom

Super Moderator

Pat Hartman

Super Moderator

Galaxiom

Super Moderator

Similar threads

Users who are viewing this thread