Display Data On Split Form

[JamesJ]

Not sure how to ask this but here goes.
In AC 2007 I have a split form that I want to display a value
that will show regardless of the row I select in the datasheet.
This is the number of vacation days one will have through-out
the year and of course it changes as vacations days get used up.

Any help will be appreciated,
James

 

[Brendan Reynolds]

Not sure how to ask this but here goes.
In AC 2007 I have a split form that I want to display a value
that will show regardless of the row I select in the datasheet.
This is the number of vacation days one will have through-out
the year and of course it changes as vacations days get used up.

Any help will be appreciated,
James

Its difficult to be specific without any knowledge of the structure of your
database, but it sounds as though the DLookup function might be what you
need. Here's a link to the on-line help topic on the DLookup function.

http://msdn2.microsoft.com/en-us/library/aa172176.aspx

 

[JamesJ]

DLookup worked fine.

Thanks,
James

Its difficult to be specific without any knowledge of the structure of
your database, but it sounds as though the DLookup function might be what
you need. Here's a link to the on-line help topic on the DLookup function.

http://msdn2.microsoft.com/en-us/library/aa172176.aspx