Re: update from data*** view

steve,

I have a listbox (sample name) on the right side of the from, whatever
is clicked by the user, it then querys a different table for that sample name
and load all the info abt that sample. on that recordset, there are order#,
order items, qty. (order# is hidden (not shown in the data***). What i m
trying to do is, when the user clicks on a record (any cell on the
data***), queries and return recordsets (where order.ordernumber =
orderdetails.ordernumber)


Thanks


"Steve Schapel" wrote:

> 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.
> >
> >
>
.