On Record Select

[Jacob]

I have a form where I am using record selector in Access 2K. I would like to
trigger an event when I select a record, is this possible???

 

[Jacob]

I am not seeing a Record Navigation. is it possible for you to tell me where
to do for this?? Thank you

Hi Jacob,

The Current event fires after record navigation - this is probably the event
you need to use.


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I have a form where I am using record selector in Access 2K. I would
like to trigger an event when I select a record, is this possible???

 

[Sandra Daigle]

Hi Jacob,

The Current event fires after record navigation - this is probably the event
you need to use.

 

[Sandra Daigle]

Hi Jacob,

You are really looking for the OnCurrent Property of the form. Using this
property you can create a current Event which will detect record navigation.
Record navigation is simply what happens when you click the record selector
for a record or use the navigation buttons to go to a record. Record
navigation also occurs when you go to a record after a search or when the
form initially opens.
--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I am not seeing a Record Navigation. is it possible for you to tell
me where to do for this?? Thank you

Hi Jacob,

The Current event fires after record navigation - this is probably
the event you need to use.


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I have a form where I am using record selector in Access 2K. I would
like to trigger an event when I select a record, is this possible???

 

[Jacob]

Sandra, thank you for your patience. I have tried this and am unable to get
it to work. with the OnCurrent here is what I have...
DoCmd.OpenForm "frmEvent",,,Recordselect,,,,

As you know, this is not working. I have tried different things.

Hi Jacob,

You are really looking for the OnCurrent Property of the form. Using this
property you can create a current Event which will detect record navigation.
Record navigation is simply what happens when you click the record selector
for a record or use the navigation buttons to go to a record. Record
navigation also occurs when you go to a record after a search or when the
form initially opens.
--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I am not seeing a Record Navigation. is it possible for you to tell
me where to do for this?? Thank you

Hi Jacob,

The Current event fires after record navigation - this is probably
the event you need to use.


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Jacob wrote:
I have a form where I am using record selector in Access 2K. I would
like to trigger an event when I select a record, is this possible???

 

[Jacob]

Yes, it is a continuous dub form on a form with a list of equipment. I would
like to select the equipment and have it open a new form. Right now I have
the Ondouble click on the equipment type. But for the end user, they do not
know to double click it. Is there an easier way I can accomplish this?

Hi Jacob,

What is Recordselect in the statement you provided?

Are you trying to open another form based on the selection in a continous
form? For that I would recommend using the DoubleClick event of the form.


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Sandra, thank you for your patience. I have tried this and am unable
to get it to work. with the OnCurrent here is what I have...
DoCmd.OpenForm "frmEvent",,,Recordselect,,,,

As you know, this is not working. I have tried different things.

Hi Jacob,

You are really looking for the OnCurrent Property of the form. Using
this property you can create a current Event which will detect
record navigation. Record navigation is simply what happens when you
click the record selector for a record or use the navigation buttons
to go to a record. Record navigation also occurs when you go to a
record after a search or when the form initially opens.
--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Jacob wrote:
I am not seeing a Record Navigation. is it possible for you to tell
me where to do for this?? Thank you


Hi Jacob,

The Current event fires after record navigation - this is probably
the event you need to use.


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Jacob wrote:
I have a form where I am using record selector in Access 2K. I
would like to trigger an event when I select a record, is this
possible???

 

[Sandra Daigle]

Hi Jacob,

What is Recordselect in the statement you provided?

Are you trying to open another form based on the selection in a continous
form? For that I would recommend using the DoubleClick event of the form.


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Sandra, thank you for your patience. I have tried this and am unable
to get it to work. with the OnCurrent here is what I have...
DoCmd.OpenForm "frmEvent",,,Recordselect,,,,

As you know, this is not working. I have tried different things.

Hi Jacob,

You are really looking for the OnCurrent Property of the form. Using
this property you can create a current Event which will detect
record navigation. Record navigation is simply what happens when you
click the record selector for a record or use the navigation buttons
to go to a record. Record navigation also occurs when you go to a
record after a search or when the form initially opens.
--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I am not seeing a Record Navigation. is it possible for you to tell
me where to do for this?? Thank you


Hi Jacob,

The Current event fires after record navigation - this is probably
the event you need to use.


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Jacob wrote:
I have a form where I am using record selector in Access 2K. I
would like to trigger an event when I select a record, is this
possible???

 

[Jacob]

Ops, I got it, you already answered it. Thanks Sandra for your help.

Hi Jacob,

What is Recordselect in the statement you provided?

Are you trying to open another form based on the selection in a continous
form? For that I would recommend using the DoubleClick event of the form.


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Sandra, thank you for your patience. I have tried this and am unable
to get it to work. with the OnCurrent here is what I have...
DoCmd.OpenForm "frmEvent",,,Recordselect,,,,

As you know, this is not working. I have tried different things.

Hi Jacob,

You are really looking for the OnCurrent Property of the form. Using
this property you can create a current Event which will detect
record navigation. Record navigation is simply what happens when you
click the record selector for a record or use the navigation buttons
to go to a record. Record navigation also occurs when you go to a
record after a search or when the form initially opens.
--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Jacob wrote:
I am not seeing a Record Navigation. is it possible for you to tell
me where to do for this?? Thank you


Hi Jacob,

The Current event fires after record navigation - this is probably
the event you need to use.


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Jacob wrote:
I have a form where I am using record selector in Access 2K. I
would like to trigger an event when I select a record, is this
possible???