OpenForm?

F

Frank

Hi all,
I have 2 Forms, Form1 (with Devices) and Form2 (with Components).
In the Form1 I have got list of Devices (with ID_Device, the field name
txtDevice). I have got list with 70 devices, when I click on the ID_Device
(1,2,3,etc) i I'd like open Form2 related on the ID_Device from Form1. I'd
like see only this Compoment wchich i choose in the Form1.
I am using Access 2007 and i try write OpenForm in VBA and i always fail.
Please help me.
 
F

Frank

Hi,
when I use:
DoCmd.OpenForm "form2", , , "DeviceID=" & DeviceID
Form2 will open but all with every Components, not reletated with ID_Device
from Form2.

Any idea?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top