How to access a field value in Access VB

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

MILKMAN ROUNDS PROJECT:

I have a simple project that has a customer table (Detail) and a "Rounds"
(master) table that contains the round details for the round each customer
belongs to....no problem.

I have created a query and then a report that selects all customers that
belong to a selected round number...fine

In the reports detail OnFormat event i want to reference the value of any
field in the underlying dataset for the report. The only way i have managed
to get access to any field value is to place a stupid label on every report
bound to the field i want to question, and make them invisible. then using
the construct MyLocalVar = Me![AnyFieldx] i am able to get to the value.

QUESTION: How do i get to read/use any value in a report WITHOUT loading a
label on the report IN the band im in so i can use it in VB?

Im sure this is easy peasy, but ive been trying for about 2 weeks now and
always give in and slap loads of hidden labels all over the report just so i
can get to the values in VB.

Best regards
Colin


.

Relevant Pages

  • Re: How to access a field value in Access VB
    ... I have a simple project that has a customer table and a "Rounds" ... table that contains the round details for the round each customer ... field in the underlying dataset for the report. ... label on the report IN the band im in so i can use it in VB? ...
    (microsoft.public.access.formscoding)
  • Re: How to access a field value in Access VB
    ... filtered by the round number for the detail i am currently on. ... I have a simple project that has a customer table and a "Rounds" ... field in the underlying dataset for the report. ... label on the report IN the band im in so i can use it in VB? ...
    (microsoft.public.access.formscoding)
  • Abuse report
    ... This is an automated response to the email you sent to the BT Customer ... All cases of abuse are taken very seriously. ... please report abuse where someone using a BT domain or a BT IP ... directly to the offender's Internet Service Provider. ...
    (uk.rec.motorcycles)
  • Re: they are bringing down unexpected, across sporting, worth parliamentary dominances
    ... round correct learnings to legally desire. ... You won't report it. ... Nowadays, Wail never ...
    (sci.crypt)
  • Re: Help ... Creating an invoice
    ... So what you will want is a query that will return the required information ... for a report to use. ... for just the records for that customer. ... > if I want that order to be placed on the invoice? ...
    (microsoft.public.access.forms)