Mouse click code?

[Mindy Bledsoe]

Hi,

I have a continuous form that has 24 process steps, id
like to write a module that allows the user to select a
start point and end point via mouse click and come up
with the number of fields in between.

the screen.activecontrol.name function works nice but i
can't get the code to accept the start and end point, is
there a method to pause the code or am i going about it
all wrong?

thanks in advance!

Mindy.

 

[Stephen Lebans]

I do not understand your request. Do you have a form set to Continuous
view that contains 24 records and you want to select a user selectable
subset of these 24 records?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Mindy B.]

Yes the form is continuous, on the record are 24 fields,
(the name of each field is a number 1,2,3,...) id like
to have the user select a range (subset?) in that record
Like field 3 to 12 for them to flag the process with the
current status. I was trying to place the two clicks
in a module to do the math on the range as well as place
the status.
I am not selecting a range of records (enumerating?) but
fields within it.

i hope i explained that right... thanks again!

Mindy.

 

[Stephen Lebans]

Without getting into a lot of VBA coding the simplest solution would be
to create a seperate popup form to allow the user to select the start
control and then the end control. Use the Screen.Previouscontrol prop
and the form's Current record property to determine which controls have
been selected. Alternatively, and perhaps an even simpler solution,
would be to popup a selection Form in single view containing the
currently selected record.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.