RE: transfer data from main form to subform

the forms recordsource is the query of the two tables.

"Sprinks" wrote:

> Gazza,
>
> Hmm. Are you saying the main form's RecordSource property is a query of the
> product details table and customer tables? If this is so, and you're linking
> on the ProductID field, you'll never be able to enter more than one detail
> record. But I don't understand what the form is meant to do--is it an order
> entry for a customer? I understand the details that you've given about your
> forms, but please describe what the form's generic purpose is.
>
> Sprinks
>
> "Gazza" wrote:
>
> > Ok thanks sprinks here goes.
> >
> > The main forms recordsource is the product details table and customer
> > details table.
> >
> > The subforms recordsourse is the product details table.
> >
> > My main form(PC1) opens up with the customer details entered and sts focus
> > on the part no text box(PN1).I enter a part no(primary key) into the text box
> > and it displays the info of the record(part no, description, price etc) from
> > a table(Product Details) and then sets focus on the quantity text box(Q1) on
> > the main form.
> > when i enter a quantity it re-sets the focus back to the part no text box on
> > the main form but it clears the line from the subform.
> >
> > The subform is set to a continuous form and i have tried setting the
> > dataentry properties of both main form to yes and no amd subform to yes and
> > no.
> >
> > Hope thats enough info to help.
> >
> > thanks
> >
> >
> >
> > "Sprinks" wrote:
> >
> > > Hi, Gazza.
> > >
> > > You don't give enough general information about what your main form is, but
> > > normally a subform is for detail records about or related to a main form
> > > record. The linking field, shown once in the main form will automatically be
> > > entered in the linking field in the subform. So the answer to your question
> > > is No.
> > >
> > > If you are creating an order, for example, that might have multiple part
> > > numbers ordered, link by the OrderNumber instead. Otherwise, post more
> > > generic information about your application and we'll try to help.
> > >
> > > Sprinks
> >
.

Relevant Pages

  • RE: transfer data from main form to subform
    ... My approach would be create a continuous subform with a dummy table, ... consisting of Part No and Quantity fields as its RecordSource. ... > table).But some customers will have a different discount for a product ... sets the discount applicable to that customer. ...
    (microsoft.public.access.forms)
  • RE: transfer data from main form to subform
    ... Are you saying the main form's RecordSource property is a query of the ... product details table and customer tables? ... > The main forms recordsource is the product details table and customer ... > the main form but it clears the line from the subform. ...
    (microsoft.public.access.forms)
  • RE: transfer data from main form to subform
    ... but I'm going to guess that your main form's RecordSource is ... items purchased by the customer, not a specific discount for each item. ... The subform is sized to display only one record, ... > the form is basically a price check form. ...
    (microsoft.public.access.forms)
  • RE: transfer data from main form to subform
    ... The reason you can only add one record in the subform is that the subform is ... sets the discount applicable to that customer. ... Discount Code field in the Product Details table that leads me to believe ... > the forms recordsource is the query of the two tables. ...
    (microsoft.public.access.forms)
  • RE: transfer data from main form to subform
    ... Ok thanks sprinks here goes. ... The main forms recordsource is the product details table and customer ... My main formopens up with the customer details entered and sts focus ... The subform is set to a continuous form and i have tried setting the ...
    (microsoft.public.access.forms)