Re: Adding new entry with specific value

Tech-Archive recommends: Fix windows errors by optimizing your registry

"Edward H via AccessMonster.com" wrote:

<snip>
> Now I just want to be able to display the value of TOP_1 query as a
> reference.
> I can't seem to get this thing to spit out 1 stinking value.
>
>

Just like before, but don't add one to it.


Me.Somecontrol = Dlookup("[ID]", "qryID_Top1")


You could also use a label (so there is no chance of it being mistaken for
an entry field):

Me.LabelName.Caption = "Last ID = " & Dlookup("[ID]", "qryID_Top1")

(**Change "LabelName" to the name of the label)


HTH
--
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)



.

Relevant Pages

  • Re: Alias
    ... Create a query on which to base your form. ... Display the Properties Window. ... Companies table joioned to SupplierID and change its alias to Suppliers. ... can I reference to Companies_1 in a form to ...
    (microsoft.public.access.formscoding)
  • SQL Code Help
    ... Could someone help me out with some SQL code to resolve the following issue? ... I need to generate one piece of SQL code to be used by a report via a query ... then display result with ID ... Reference to TF is to a temporary reference ...
    (microsoft.public.access.queries)
  • Re: newbie: j2me - NullPointerException problems
    ... public class chemistry extends MIDlet implements CommandListener ... private static Display display; ... reference to the Display object for the MIDlet. ...
    (comp.lang.java.programmer)
  • Help on creating a referance number
    ... Hi everyone and Merry Christmas, ... I have an interesting reference number that I'm trying to program that will ... display on a form. ... the form's control source is a query. ...
    (microsoft.public.access.formscoding)
  • Re: Name change
    ... (application icons displayed on the dock often display information). ... slows down Windoze) - four CPU cores in two chips. ... It's displayed by the Temperature Monitor app, ...
    (uk.people.support.depression)