Please help! Where Condition in a Macro

[Lainni]

I have very little knowledge of VB and I thought Access 2007 would be easier
but I am still running into problems. I have a split form that contains
records of distributors and I would like users to be able to click on the
distributor's id and have a form open up that contains all that distributors
information. I have both forms set up but I am having trouble with the macro
for the on click event. I used the OpenForm action and
Form Name Distributor1
View Form
Where Condition [DistributorID]=Forms!Distributor1!DistributorID

Do I need to set up a temp variable first and a procedure in case of an error?

 

[Wayne-I-M]

[DistributorID]=[Forms]![MainFormName]![SubFormName].[Form]![DistributorID]

 

[Lainni]

Wayne, thank you for the help, but I am still having trouble. I plugged the
where clause into my macro but I am still having problems with it. When I
click on the DistributorID, two parameter boxes pop up one after the other
asking for the DistributorID. Do I need to set temporary variable before
this?

Thanks

[DistributorID]=[Forms]![MainFormName]![SubFormName].[Form]![DistributorID]


--
Wayne
Manchester, England.

I have very little knowledge of VB and I thought Access 2007 would be easier
but I am still running into problems. I have a split form that contains
records of distributors and I would like users to be able to click on the
distributor's id and have a form open up that contains all that distributors
information. I have both forms set up but I am having trouble with the macro
for the on click event. I used the OpenForm action and
Form Name Distributor1
View Form
Where Condition [DistributorID]=Forms!Distributor1!DistributorID

Do I need to set up a temp variable first and a procedure in case of an error?

 

[Wayne-I-M]

This means that DistributorID is not a control name on the forms and you
access is asking you to provide it

Note the control name is "not" always the same as the field name it is based
on.

Open the form in design view and then the properties box for the control and
check the "name" not the source


--
Wayne
Manchester, England.

Wayne, thank you for the help, but I am still having trouble. I plugged the
where clause into my macro but I am still having problems with it. When I
click on the DistributorID, two parameter boxes pop up one after the other
asking for the DistributorID. Do I need to set temporary variable before
this?

Thanks

[DistributorID]=[Forms]![MainFormName]![SubFormName].[Form]![DistributorID]


--
Wayne
Manchester, England.

I have very little knowledge of VB and I thought Access 2007 would be easier
but I am still running into problems. I have a split form that contains
records of distributors and I would like users to be able to click on the
distributor's id and have a form open up that contains all that distributors
information. I have both forms set up but I am having trouble with the macro
for the on click event. I used the OpenForm action and
Form Name Distributor1
View Form
Where Condition [DistributorID]=Forms!Distributor1!DistributorID

Do I need to set up a temp variable first and a procedure in case of an error?