Re: update from data*** view

Jeff,

Do you mean that this subform is a subform on a main form which contains the order#? If so, you can use the Link Master Fields and Link Child Fields properties of the subform to control this. If this is not what you mean, how is the subform meant to "know" which order# to put in?

By the way, it is not a good idea to use a # as part of a field name.

--
Steve Schapel, Microsoft Access MVP


Jeff wrote:
Hi,
I have a subform in the Data*** view, not all the fields are displayed. When a new record is entered, the hidden fields are not updated. e.g. I know the primary key of the record and it's not displayed on the subform. How can I manually pass that in when the record is updated.

let say the record has the following fields
order# (hidden), Qty (shown), item# (shown).
when the user can only enter Qty and Item#, how do I append Order# to the record?


Thanks.


.

Loading