Re: For MVP: data entry from combo box line items

Tech-Archive recommends: Speed Up your PC by fixing your registry

anonymous_at_discussions.microsoft.com
Date: 02/25/04

  • Next message: anonymous_at_discussions.microsoft.com: "Re: For MVP: data entry from combo box line items" 
    Date: Tue, 24 Feb 2004 19:06:01 -0800

    Roger,

    Both your responses are neat, simple, and much
    appreciated. Don't know why I still feel paranoid about
    seeing Customer ID's in a table without the associated
    name, but I still do. Looks like I could also customize
    your second solution to cause a post to bound text boxes
    rather than only to unbound. Thanks again ...
    >-----Original Message-----
    >Well, I'm not an MVP, but...
    >
    >There is no need to need to copy the FirstName and
    LastName into the other
    >table, if that's what you're thinking. Storing the ID is
    enough. You can
    >join the tables back together later in a query or report.
    >
    >However, there is no problem with simply *displaying*
    those values. There
    >are a number of ways to do this. One would be to have
    the first and last
    >name text boxes (txtFirst and txtLast) remain unbound.
    Then in the
    >AfterUpdate Event of the Customer ID combo box do
    something like this:
    >
    >Me.txtFirst = cboCustomerID.Column(1)
    >Me.txtLast = cboCustomerID.Column(2)
    >
    >
    >--
    >--Roger Carlson
    > www.rogersaccesslibrary.com
    > Reply to: Roger dot Carlson at Spectrum-Health dot Org
    >
    >
    >"Bill Morgan" <willmorgan@lisco.com> wrote in message
    >news:096101c3fb09$791bac40$a501280a@phx.gbl...
    >> Problem: I need to ensure that data entry personnel
    always
    >> enter the Customer LastName and FirstName that
    correspond
    >> to that Customer's ID Number.
    >>
    >> They pick (click on) the Customer ID from a combo box
    that
    >> is three columns wide and also lists the Customer
    LastName
    >> and FirstName. The combo box is based on a query that
    >> comprises all Customer ID's, LastNames, FirstNames, and
    it
    >> is bound to the Customer ID field on the form's
    underlying
    >> table. When they click on the Customer in the combo box,
    >> the Customer ID posts to the Customer ID field (text
    box).
    >>
    >> What is the cleanest/simplest way to make the Customer
    >> FirstName and LastName (columns 2 and 3 of the combo
    box)
    >> also automatically post to the forms LastName FirstName
    >> fields at the same time that the Customer ID posts?
    >>
    >> Thanks for any help youc an provide ...
    >>
    >> Bill Morgan
    >> willmorgan@lisco.com
    >>
    >>
    >
    >
    >.
    >

  • Next message: anonymous_at_discussions.microsoft.com: "Re: For MVP: data entry from combo box line items"

    Relevant Pages

    • Re: access 2003
      ... of the combo boxes which is either ChooseCust or ChooseJob. ... except for Job in place of Choose this query creates the PreBilling report ... both criteria values that are coming from the combo boxes into the query. ... when you remove the criteria for the Customer and Job fields, ...
      (microsoft.public.access.conversion)
    • Re: Trouble with sendkeys - Alternative?
      ... One customer can be involved in many sales (but not ... You can then create a query based on your three tables. ... If you want to include the sum of the "Value" columns in a crosstab query, ... Graham Mandeno ...
      (microsoft.public.access.formscoding)
    • RE: Search facility query
      ... I have put the three boxes on the main form. ... The name of the control on the main form for customer name ... The name of the table or query that is the record source for the main form. ... Set rstClone = Me.RecordsetClone ...
      (microsoft.public.access.modulesdaovba)
    • Re: Crosstab query by quarter nightmare
      ... The Cartesian query gives every combination of customer and savings in the ... I am getting the same count for each savings. ... So you are recording when a customer came on board. ... So the whole crosstab relies ...
      (microsoft.public.access.queries)
    • Re: [PHP] OOP slow -- am I an idiot?
      ... OOP has overhead. ... That saves you putting wasteful SQL queries in your ... If you need to do a complex query with a couple of joins and such, ... I want to create a "customer" class which fetches its attributes from a ...
      (php.general)