Hello,

I'm kinda new to this, and any help would be very welcome.

When I open a form (which is linked to table A), I want to perform a query
on that same table.

I need to know the max of field 'HUB' and want to add it with 1. This
value(MyVar) I want to show on the form, so that I know which HUB number I
can enter. (I'm not working with autonum on this table).

Which script do I have to write.

It is something like:

MyVar = Max(TableA.HUB)+1


Thanks for your time and attention.

"TTD_hck" <ttd@hotmail.com> wrote in message
news:blr9hs$207u$1@beast.euro.net...[color=blue]
> Hello,
>
> I'm kinda new to this, and any help would be very welcome.
>
> When I open a form (which is linked to table A), I want to perform a query
> on that same table.
>
> I need to know the max of field 'HUB' and want to add it with 1. This
> value(MyVar) I want to show on the form, so that I know which HUB number I
> can enter. (I'm not working with autonum on this table).
>
> Which script do I have to write.
>
> It is something like:
>
> MyVar = Max(TableA.HUB)+1
>
>
> Thanks for your time and attention.[/color]


Try the DMAX function:

=DMax("[HUB]","TableA") + 1


Fletcher

Thanks,

works very well.


"Fletcher Arnold" <fletch@home.com> schreef in bericht
news:blrdm0$oc9$1@sparta.btinternet.com...[color=blue]
> "TTD_hck" <ttd@hotmail.com> wrote in message
> news:blr9hs$207u$1@beast.euro.net...[color=green]
> > Hello,
> >
> > I'm kinda new to this, and any help would be very welcome.
> >
> > When I open a form (which is linked to table A), I want to perform a[/color][/color]
query[color=blue][color=green]
> > on that same table.
> >
> > I need to know the max of field 'HUB' and want to add it with 1. This
> > value(MyVar) I want to show on the form, so that I know which HUB number[/color][/color]
I[color=blue][color=green]
> > can enter. (I'm not working with autonum on this table).
> >
> > Which script do I have to write.
> >
> > It is something like:
> >
> > MyVar = Max(TableA.HUB)+1
> >
> >
> > Thanks for your time and attention.[/color]
>
>
> Try the DMAX function:
>
> =DMax("[HUB]","TableA") + 1
>
>
> Fletcher
>
>
>[/color]