Navigate to CURRENT record On Open

  • Thread starter Thread starter Tom McMillion
  • Start date Start date
T

Tom McMillion

First of all let me say this sight offers an invaluable
service to folks like me. Thanks to all those who have
helped me to this point. I have learned a great deal
here over the last week or so.

I have 2 forms which were created from the same table.
Form #1 displays certain information for the currently
selected record. Form #2 is a pop up form which is
launched from a command button on Form #1. The
*intended* purpose of Form #2 is to display the currently
selected record from Form #1, have an operator change a
Status list box from Queue to Complete, then click a
button to auto enter a date/time stamp when this change
occurred, and to 'initial' the change via the User ID
field.

Bottom line is I need Form #2 when it opens to
programatically locate to the currently selected record
on Form #1. How do I do this? Or is it possible?

I've checked the GoToRecord command available when
setting up a Macro for the button which launches Form #2,
but the only options seem to be go to New, First, Last,
and optionally "Offset" so many records. I've checked the
Access help file and 2 books that I have, but I can't
find what I'm looking for.

Thanks in advance for any help.
 
Yes I am using a macro. I found the section you were
referring to, and that is somewhat helpful and certainly
showed me an option that I wasn't aware of. I read the
help file where it mentions an SQL Where clause but
honestly don't know how to write such a statement.

What kind of statement do I need in order tell the form,
in effect, "Open form [OrderComplete] to the current
record on form [Orders] based on value [abcdefg] in field
Forms.Orders.OrderNumber" or however you say it.

Sorry I guess the fact that it's late for me on the East
Coast doesn't help my pititul attempt at explaining this.

Thanks for your reply,
Tom
-----Original Message-----
Hi,
If you are using a macro, check out the 'where condition' argument of the
OpenForm action in help.
This will allow you to open your form and display the details of the current record.

--
HTH
Dan Artuso, Access MVP


"Tom McMillion" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Hi,
Here is what Help says:

To open a form and restrict its records to those specified by the value
of a control on another form, use the following expression:
[fieldname] = Forms![formname]![controlname on other form]

The fieldname argument is the name of a field in the underlying table or query of the form you want to open.
The controlname on other form argument is the name of the control on the other form that
contains the value you want records in the first form to match.

I don't know what your [fieldname] is so...
[fieldname] = Forms![Orders]![OrderNumber]

--
HTH
Dan Artuso, Access MVP


Tom McMillion said:
Yes I am using a macro. I found the section you were
referring to, and that is somewhat helpful and certainly
showed me an option that I wasn't aware of. I read the
help file where it mentions an SQL Where clause but
honestly don't know how to write such a statement.

What kind of statement do I need in order tell the form,
in effect, "Open form [OrderComplete] to the current
record on form [Orders] based on value [abcdefg] in field
Forms.Orders.OrderNumber" or however you say it.

Sorry I guess the fact that it's late for me on the East
Coast doesn't help my pititul attempt at explaining this.

Thanks for your reply,
Tom
-----Original Message-----
Hi,
If you are using a macro, check out the 'where condition' argument of the
OpenForm action in help.
This will allow you to open your form and display the details of the current record.

--
HTH
Dan Artuso, Access MVP


"Tom McMillion" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
.
Click to expand...
Click to expand...
 
Dan,

I apologize for my late night message. With your help I
believe I have it now. Thanks so much for the additional
explanation. What a tremendous help this is.

Kind regards,
Tom
-----Original Message-----
Hi,
Here is what Help says:

To open a form and restrict its records to those specified by the value
of a control on another form, use the following expression:
[fieldname] = Forms![formname]![controlname on other form]

The fieldname argument is the name of a field in the
Click to expand...
underlying table or query of the form you want to open.
The controlname on other form argument is the name of
Click to expand...
the control on the other form that
contains the value you want records in the first form to match.

I don't know what your [fieldname] is so...
[fieldname] = Forms![Orders]![OrderNumber]

--
HTH
Dan Artuso, Access MVP


"Tom McMillion" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
Yes I am using a macro. I found the section you were
referring to, and that is somewhat helpful and certainly
showed me an option that I wasn't aware of. I read the
help file where it mentions an SQL Where clause but
honestly don't know how to write such a statement.

What kind of statement do I need in order tell the form,
in effect, "Open form [OrderComplete] to the current
record on form [Orders] based on value [abcdefg] in field
Forms.Orders.OrderNumber" or however you say it.

Sorry I guess the fact that it's late for me on the East
Coast doesn't help my pititul attempt at explaining this.

Thanks for your reply,
Tom
-----Original Message-----
Hi,
If you are using a macro, check out the 'where condition' argument of the
OpenForm action in help.
This will allow you to open your form and display the details of the current record.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top