On Record Select

  • Thread starter Thread starter Jacob
  • Start date Start date
J

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???
 
I am not seeing a Record Navigation. is it possible for you to tell me where
to do for this?? Thank you


Sandra Daigle said:
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???
Click to expand...
Click to expand...
 
Hi Jacob,

The Current event fires after record navigation - this is probably the event
you need to use.
 
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


Sandra Daigle said:
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???
Click to expand...
Click to expand...
Click to expand...
 
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.


Sandra Daigle said:
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


Sandra Daigle said:
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???
Click to expand...
Click to expand...
Click to expand...
 
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?








Sandra Daigle said:
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.


Sandra Daigle said:
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???
Click to expand...
Click to expand...
Click to expand...
 
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.


Sandra Daigle said:
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???
Click to expand...
Click to expand...
Click to expand...
 
Ops, I got it, you already answered it. Thanks Sandra for your help.


Sandra Daigle said:
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.


Sandra Daigle said:
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???
Click to expand...
Click to expand...
Click to expand...
 
Back
Top