Call records from MS-Access to vantage vb form

Please help,

If this is not possible, Can you help me build a vb program for labor
dtl table.

I would like to add 3 fields in vb form

start counter -> initial value = 0
but for next labordtl record if the shift,date and job number is
same then the start counter is updated by 0+ start counter of last
record.

End counter = 0 (initially)
but for next shift for the same job number end counter = start
counter of previous shift.

Cycle time = 0(initially) but update each next record with the value
entered for same shift and job number.

Please ask if i am not clear.but please reply with some clue.



if shift <> shift of next record then initial value = 0
again.cahnges
--- In vantage@yahoogroups.com, "sharma_nalini" <sharma_nalini@y...>
wrote:
> Right now we are usng MS-Access database for our labour details,
but
> very soon wnat to start using vantage data collection.
>
> We are not ready right now to stop use of MS- Access database, so
we
> planned that only few of the employees like shift supervisors will
> enter the entries.
>
> We do not see all the fields in vantage wht we enter right now in
> Access.
>
> Is it possible to call a particular record via vb form in the
labour
> details
>
> e.g
> If vantage.jobnum = access.jobnum
> and vantage.empid = access.empid.
> then display access form with details for particular empid and job
num.
Right now we are usng MS-Access database for our labour details, but
very soon wnat to start using vantage data collection.

We are not ready right now to stop use of MS- Access database, so we
planned that only few of the employees like shift supervisors will
enter the entries.

We do not see all the fields in vantage wht we enter right now in
Access.

Is it possible to call a particular record via vb form in the labour
details

e.g
If vantage.jobnum = access.jobnum
and vantage.empid = access.empid.
then display access form with details for particular empid and job num.