VBA to update a complete field.

[Perfac]

Can someone confirm. If an unbounded text field is placed on a form, can it keep the info when closed and open again?

I use Update queries and it works, but I prefer to have the VBA. Below follow detail of my situation. If someone can help me with the VBA code.
a. The field is in query q01AssetsTypes.
b. The fieldname is "PrefixA".
c. There is an unbounded text field on the form f01AssetsTypes named txtPrefix.

I want on "After update", or "click" on the form txtPrefix to update the field PrefixA for the input to display the code for every record.

[Welshgasman]

Why unbound?
Just have it bound and disable it?

[Perfac]

I use a Prefix on every form to go in front of the number. Yes , I know to put it in the format space in the table, but I respect your time. My app has got more than 250 tables. The prefix consists of three letters. No Prefix for any form's numbers may be the same. I want to be able to change it even if it almost never change, then it must update the query. I have a successful way to do it with an update query, but I do not want to create 250 Update queries. I would like to be helped with the VBA.

[Micron]

Maybe
CurrentDb.Execute "UPDATE q01AssetTypes SET q01AssetTypes.PrefixA = '" & Forms!f01AssetsTypes.txtPrefix & "'"

Note that since there is no criteria there, all records will get that value, which may or may not be what you want:

display the code for every record.

It also assumes that the textbox value is a string and not a date. The form would have to be open and a value must be in the unbound control. I strongly suggest you do not run record modifying code that you are given on your real data - copy the table or db and play with the copy.

[Perfac]

Fantastic, thank you. Yes that was exactly what I want, and works correct. I thought I can solve the next part myself, but no. On the images things can be seen.

a. RecordCodeC is a calculated field in the local table and query. Calculation is PrefixA & "" & AssetsTypesNumber.
b. RecordCodeA is a field in a linked query named q01CombinedEntities, most of my queries link to q01CombinedEntities.
c. I want RecordCodeA to equal RecordCodeC after the same event. After your line.
d. You may see following your advice I tried the same code in the last line of my image.
e. The result in RecordCodeA is a 7 after every Prefix? The 7th record was open during activation.

What am I missing?

[Micron]

Sorry I haven't had time to get back to this over the last little while. If the real problem with your last post is item e, then if you review my solution you'll see that I said that whatever you apply as an update would happen to every record if you didn't apply criteria. Your afterupdate code does not apply any criteria. I cannot tell which of those query fields you might want to apply criteria to. Perhaps 1, 2 or 4, or some combination of the 3 fields.