List box to open another form

[NDClark]

I have Form (A) which has a List box. I have the List Box set up to open
Form (B). Form (B) is a sub form of a Data Sheet (C).

My problem when the data (DATE) is clicked on the List Box, it opens the
Form (B) to a new entry. I need it to open the data (DATE) I click.

 

[Stefan Hoffmann]

hi,

I have Form (A) which has a List box. I have the List Box set up to open
Form (B). Form (B) is a sub form of a Data Sheet (C).

My problem when the data (DATE) is clicked on the List Box, it opens the
Form (B) to a new entry. I need it to open the data (DATE) I click.

How do you open it? If you use DoCmd.OpenForm take a look at the
[WhereCondition] parameter.


mfG
--> stefan <--

 

[NDClark]

I have a macro active on the list box. In the where condition I have linked
the ID fields and it still ask for a ID Parameter.
I have the following in the where condition [ID]=Forms![Surgery]!ID

Is there something amiss with this code?

hi,

I have Form (A) which has a List box. I have the List Box set up to open
Form (B). Form (B) is a sub form of a Data Sheet (C).

My problem when the data (DATE) is clicked on the List Box, it opens the
Form (B) to a new entry. I need it to open the data (DATE) I click.

How do you open it? If you use DoCmd.OpenForm take a look at the
[WhereCondition] parameter.


mfG
--> stefan <--

 

[Stefan Hoffmann]

hi,

I have a macro active on the list box. In the where condition I have linked
the ID fields and it still ask for a ID Parameter.
I have the following in the where condition [ID]=Forms![Surgery]!ID

If it asks for a parameter, then you have some kind of error, normally a
typo. Check the name of your fields.


mfG
--> stefan <--

 

[NDClark]

When I click the data in the list box, it does open the correct form. It
just will not open the form to the correct entry.

hi,

I have a macro active on the list box. In the where condition I have linked
the ID fields and it still ask for a ID Parameter.
I have the following in the where condition [ID]=Forms![Surgery]!ID

If it asks for a parameter, then you have some kind of error, normally a
typo. Check the name of your fields.


mfG
--> stefan <--

 

[Larry Linson]

When I click the data in the list box, it does open the correct
form. It just will not open the form to the correct entry.

Then, you can assume that it is not the name of the form in which you made a
typographical error, so you can check other possibilites. The
WhereCondition argument, by the way, does not determine the Form that is
opened, only matches a Field in the Form's Record Source to a value you
supply.

Larry Linson
Microsoft Office Access MVP

hi,

I have a macro active on the list box. In the where condition I have
linked
the ID fields and it still ask for a ID Parameter.
I have the following in the where condition [ID]=Forms![Surgery]!ID

If it asks for a parameter, then you have some kind of error, normally a
typo. Check the name of your fields.


mfG
--> stefan <--

 

[NDClark]

Hi Larry, yes, I understand what you said. However, my issue is, the form is
opening to NEW. I want to be able to click the entry in the list box and
open the entry to edit it.

When I click the data in the list box, it does open the correct
form. It just will not open the form to the correct entry.

Then, you can assume that it is not the name of the form in which you made a
typographical error, so you can check other possibilites. The
WhereCondition argument, by the way, does not determine the Form that is
opened, only matches a Field in the Form's Record Source to a value you
supply.

Larry Linson
Microsoft Office Access MVP

hi,

NDClark wrote:
I have a macro active on the list box. In the where condition I have
linked
the ID fields and it still ask for a ID Parameter.
I have the following in the where condition [ID]=Forms![Surgery]!ID
If it asks for a parameter, then you have some kind of error, normally a
typo. Check the name of your fields.


mfG
--> stefan <--

 

[Stefan Hoffmann]

hi,

Hi Larry, yes, I understand what you said. However, my issue is, the form is
opening to NEW. I want to be able to click the entry in the list box and
open the entry to edit it.

Set the "Data Mode" to "Edit".


mfG
--> stefan <--