How to access a field value in Access VB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows 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: Subreport Problem
    ... report is sorting the account numbers. ... more if you think it's possible a customer could have more than 24 accounts. ...  I have a subreport in the detail section of the "receipt" ...
    (microsoft.public.access.reports)
  • 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)