Additional Change to Open Other Form Command Button

[Nanette]

I have a Open Other Form Command Button that opens another form. See previous
question.

When the command button opens the second form, I'd like it to open the
second form and show the details for the part number that was on the first
form. The first forms base form is tblParts and has a subform of
tblPartDetails. The second form has a different base form (tblCabinets) and a
subform (tblPartDetails).

Is there a macro to do this? I'm hopping so because my VB skills are very
minimal.

 

[Ruel Cespedes via AccessMonster.com]

No Macros! VBA is the only way. I can help you if you want to learn VBA.

Ruel

 

[Nanette]

Yes, I'm tryinig to learn VBA and would like to learn more.

 

[Ruel Cespedes via AccessMonster.com]

Nanette,

I'm going to assume some things here.

1) You know how to make Macros
2) You know how to use the Toolbar

Well there is a Tool on the Toolbar that will convert your macros into code.
This is a great place to start.

Goto any macro you have created and select it. Then goto "Tools" >> "Macro"
This will convert your macro into a module. Open this module and see how
your macro looks in code.

Here's a great book to start reading:

http://www.dummies.com/WileyCDA/DummiesTitle/productCd-0764574116.html

Ruel

 

[Van T. Dinh]

While I agree that VBA is the way to go, there is a OpenForm Macro that has
the same Filter argument and WhereCondition argument that can be used to
filter the second Form ...

 

[Van T. Dinh]

Check Access Help on the OpenForm Macro action, paying attention to the
"Where Condition" argument.

There is an example in the Help topic also.