Re: Forms and Combo Boxes

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

From: Reggie (nospam_chief_at_smittysinet.com)
Date: 06/11/04 

Date: Thu, 10 Jun 2004 18:29:00 -0700

Joe, If you want to store the value you select in your combobox to a field
in your table you need to have the combobox bound to that field. To do so
open the form in design view. Double-click on the combobox to open the
properties window. Select the Data tab and set the Control Source to the
field you want by selecting it from the drop down list. Set the rowsource
to your price list. Now when you select a price from the list the value
will be store in the field you've selected as your control source. As far
as the computed value goes, it's not advised to store a derived value in
your table's. Simple place a control on your form/report to display the
value when you want to see it. 

-- 
Reggie
----------
"Joe" <anonymous@discussions.microsoft.com> wrote in message
news:1afb901c44f44$cce38610$a101280a@phx.gbl...
> I am a beginner at Access so I don't know much.  I am
> trying to create a form to fill in a table so I can run
> queries on the information in that table.  I will be
> printing a report from each record. My form has a combo
> box that references a price list.  It also has a control
> that computes line item prices from the item found in the
> combo box.  My problem is, the data pulled from the list
> in the combo box and the computed box are not moving to
> the table.  Can anyone help???
>
> Thanks
>
> Joe

Relevant Pages

  • Re: Forms and Combo Boxes
    ... >Joe, Set the After Update event of the combo to something ... >> item I select AND the price to move to the data table. ... >> combobox to open the ... >> Control Source to the ...
    (microsoft.public.access.forms)
  • Re: Forms and Combo Boxes
    ... Joe, Set the After Update event of the combo to something like this. ... > item I select AND the price to move to the data table. ... If you want to store the value you select in your> combobox to a field ... Select the Data tab and set the> Control Source to the ...
    (microsoft.public.access.forms)
  • Re: Forms and Combo Boxes
    ... My price moves but the item selected does not. ... If you want to store the value you select in your ... >in your table you need to have the combobox bound to ... Control Source to the ...
    (microsoft.public.access.forms)
  • Re: Y&R OT The Word I heard
    ... so: "Joe went to the store with myself ... and a friend" or "Joe went to the store with a friend and I" instead ... for a few years before law school, but I haven't done much since. ...
    (rec.arts.tv.soaps.cbs)
  • Re: {OT} Joe Bidens Designer Cufflinks
    ... Joe Biden's sense of style has long been: Never let them see you rumpled. ... and grays and he prefers "no wrinkle" shirts. ... store manager of the Jos. ... "I think it's a Delaware thing," Steimle says. ...
    (alt.autos.toyota)