Display data from key value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a tabular (Continuous) form (for tblLines)

The key for tblLines is LineID (number).

When the form opens, I would like to display the data from a specific LineID
(onwards). I calculate the LineID based on some parameters.

I tried to set the value of the LineID in an OnEnter Event for the form, but
got an error "not allowed to enter a value for this field"

Any idea?
 
Such a simple solution!!!

I went around and around :)

Yes! it worked... all I have to do is create a query and for the LineID I
calculated my value - works like a charm... thanks a bunch!


--
Blessings,
MM Spirit Guide
http://www.MMSpiritGuide.com


KARL DEWEY said:
I would use a query for source with the following as criteria in the query --
=[Enter LineID]
Click to expand...

This will pull that LineID and all after.

MM Spirit Guide said:
Hello,

I have a tabular (Continuous) form (for tblLines)

The key for tblLines is LineID (number).

When the form opens, I would like to display the data from a specific LineID
(onwards). I calculate the LineID based on some parameters.

I tried to set the value of the LineID in an OnEnter Event for the form, but
got an error "not allowed to enter a value for this field"

Any idea?
Click to expand...
Click to expand...
 
Back
Top