RE: transfer data from main form to subform

Sorry i got it.
not checked my mail today.
just what i needed thanks very much for your help


"Gazza" wrote:

> sorry but i dont quite understand what you mean by a dummy table.
> have i got to create another table with only the two fields(part no and
> quantity)
> or a query based on the product details table with only the 2 fields selected.
>
> "Sprinks" wrote:
>
> > Hi, Gazza.
> >
> > OK.
> >
> > My approach would be create a continuous subform with a dummy table,
> > consisting of Part No and Quantity fields as its RecordSource. Place a combo
> > box with the RowSource set to the identical query statement as you had for
> > your subform's RecordSource, and a textbox for the quantity. You could then
> > add multiple part numbers directly into the dummy table. All other fields
> > can be displayed using the combo box' Column property.
> >
> > For example, to display the Description (the 2nd column in the query), set
> > an unbound textbox to
> >
> > =YourComboBox.Column(1)
> >
> > Be sure to set the combo box' Bound Column to 1, the Column Count to 6, the
> > LimittoList property to Yes, and the ControlSource to the Part No field in
> > the dummy table.
> >
> > The combo box will limit the selections to parts in your Product table, and
> > you can make any calculations you need, displaying them in other textboxes.
> >
> > Hope that helps.
> >
> > Sprinks
> >
> > "Gazza" wrote:
> >
> > > thanks for the advice.
> > >
> > > Basically the discount is set on a product group(see product details
> > > table).But some customers will have a different discount for a product
> > > group.That was going to be my next problem to tackle.
> > >
> > > This form is only used when customers phone in for a price query on a number
> > > of items then the salespeople can open up form1 and type in the customer id
> > > and press the enter key.This in turn will open up the other form so i can
> > > enter a number of part numbers and it will give me a total price according to
> > > the specific customer.I know there is a few other bits that i have to add to
> > > the form (just my own weird way of doing things)but i can sort that out
> > > afterwards unless you actually need this done beforehand.
> > >
> > > hope this is enough and thanks again
> > >
> > > "Sprinks" wrote:
> > >
> > > > Hi, Gazza.
> > > >
> > > > The reason you can only add one record in the subform is that the subform is
> > > > currently linked on Part No, which is a field in the RecordSource of the
> > > > subform, and an unbound control on the main form. Whatever part number has
> > > > been entered in the footer is the only one that will show up in the subform.
> > > >
> > > > This is a very unusual way to use a subform. Normally, a subform is linked
> > > > on a field common to the respective record sources of the main and the
> > > > subform. Before advising you of a way to allow multiple part numbers,
> > > > though, I'll need to understand your application better.
> > > >
> > > > You mentioned in a previous that entering the CustomerID, presumably on the
> > > > previous form, sets the discount applicable to that customer. But there is
> > > > no Discount field in your Customer Details table. There is, however, a
> > > > Discount Code field in the Product Details table that leads me to believe
> > > > that the discount is product-specific. Both of these are hard to understand,
> > > > because in my experience, discount is related to an order quantity.
> > > >
> > > > So please explain in detail how discounts are to be applied. For example,
> > > > are they related to a specific product, a specific order quantity, a specific
> > > > customer? Or a combination thereof?
> > > >
> > > > Once I understand your intent, I'll be able to recommend a solution.
> > > >
> > > > Sprinks
> > > >
> > > > "Gazza" wrote:
> > > >
> > > > > 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: Overview of data
    ... Dummy is the dummy table with one record for each desired time. ... After that I put this new query into my cross ... Is there another way to get this than with cross tab queries? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Overview of data
    ... Dummy is the dummy table with one record for each desired time. ... with all the times and a query that showed all ... Is there another way to get this than with cross tab queries? ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Open a read-only form to a blank record
    ... form's load event; however, since it is read only, you can't do that. ... you will have to use a query that filters the dummy ... Another way would be to use a Union Query and create the dummy record in the ... FROM tblMdbList UNION SELECT Null As MDB_CLIENT, Null As MDB_REGION, Null ...
    (microsoft.public.access.forms)
  • Re: Preventing duplicates
    ... :>> parameterize it, and run the saved query from ASP. ... I created a dummy table, called dummy, same two fields. ...
    (microsoft.public.inetserver.asp.db)
  • Re: pasting text into a text box
    ... Create a textbox with some text in your 2007 file. ... Create a dummy chart in 2003 Excel ... Jon Peltier, Microsoft Excel MVP ...
    (microsoft.public.excel.charting)