Re: Automatically displaying values on a Form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,
Not quite sure what you're sfter here but...
You can include the field you want in the the query that feeds the combo.
Then you can populate a text box by referencing that column in your combo:

Me.yourTextBox = Me.yourCombo.Column(2)

adjust the column number as neccessary

--
HTH
Dan Artuso, Access MVP


"Larry" <Larry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:B5CA4842-EE72-410D-9770-1819094C41B2@xxxxxxxxxxxxxxxx
> Hi,
>
> I using a Combo box on a form from which the user can make a selection from
> a Table. Each selection also has a value assigned in an adjacent field. I
> would like for the value of the slection to automatically come forward to the
> Form when the selection is made. I'm using the Form to enter data into a
> predefined Table. The only way I've been able to get the value of the
> selection is by using a second Combo Box. It's annoying for the user. This
> should be simple - I've even managed to do it before but can't remeber how I
> did it. Really need some help on this one.
>
> Thanks - - -
>


.

Relevant Pages

  • RE: Designing Query - Help Please ASAP
    ... Paste the above SQL into a new blank query in SQL view and save it while ... "tmdrake" wrote: ... "Ken Sheridan" wrote: ... If I make a selection in the ProjectID box = then the subform will ...
    (microsoft.public.access.queries)
  • RE: Code using list box and multi select option
    ... OK I understand you make a selection in your query that refers to a field on ... once in using the filter in the code. ... Dim strFltr As String ...
    (microsoft.public.access.formscoding)
  • RE: Code using list box and multi select option
    ... I assume you have other selection criteria in the query that also point to ... In your original code, you only had 1 query, the one I told you to change to ... You can simply resolve this by applying the same filter to those reports. ...
    (microsoft.public.access.formscoding)
  • RE: Code using list box and multi select option
    ... the field to just open the query without a selection and use a filter to ... a filter wouldn't work for these purposes. ... OK I understand you make a selection in your query that refers to a field on ... Dim strFltr As String ...
    (microsoft.public.access.formscoding)
  • Re: Selecting Random Records
    ... SET LastMailingDate = Date ... How do you update the random selection query so that the selected field reflects the current day's date? ...
    (microsoft.public.access.queries)