Very Simple Update Qry Question

[troy]

I would like to reconfirm what each of these fields are in a Query grid..

Field: is this the target field where the new info will go?
Table: Is this the target table where the above field is located?
Update to: If I want to update my table and field. Can I put this expression
in the box?
dbo_TblProductVersion.productversion

Here is what I want to do.

Update fields in a table if someone enters new data. I just want to make
sure I am updating to the correct table and filed. Is the above info correct?

 

[Ken Snell \(MVP\)]

Answers inline....
--

Ken Snell
<MS ACCESS MVP>

I would like to reconfirm what each of these fields are in a Query grid..

Field: is this the target field where the new info will go? Yes.

Table: Is this the target table where the above field is located? Yes.

Update to: If I want to update my table and field. Can I put this
expression
in the box?
dbo_TblProductVersion.productversion

Yes, but I strongly suggest that you use [ ] characters so that ACCESS/Jet
don't think you want to update to the text string
"dbo_TblProductVersion.productversion" in case the field is a text or memo
field:
[dbo_TblProductVersion].[productversion]