Enter another form based on a subform without writing code

[Cwwrig]

What is the easiest way to access another form based on the information in a subform? I prefer not to write code since I'm a beginner.

I have table "Employees" and a table "Projects" with a Many to Many relationship. I have a form designed that allows users to enter project information and assign themself to the project.

I would like users to be able to easily view the projects they're assigned to (I assume another Mainform (employees) with a subform (projects) would be the best way to do this. But when they see their projects in the subform how can I easily take them into that record to update it?

 

[pbaldy]

Code or a macro. Might as well get in the pool.

http://www.baldyweb.com/wherecondition.htm

http://www.baldyweb.com/FirstVBA.htm

 

[SmallTime]

If you really don't want to write code yourself why not create a button and use the wizard, it'll guide you step by step and write the code for you.

Eventually you'll have to join the fray as the wizard is limited to quite basic operations.

Take care
SmallTime

 

[Cwwrig]

O.k. the first two links are helpful when I attempt to write this on my own. I would like to see how the wizard does it in order to see it first, and then try and mimic it on my own.

My 2nd question is when I use the command button wizard and add it to the subform why is it not visible? I can see it in design view, but not the normal form view. I thought I would have to add it there in order for the command line to appear on each row. (My subform is in a datasheet format)

 

[pbaldy]

One of the many reasons I don't use datasheet format. If you want to keep it in datasheet, you can use the double click event of a textbox.