Open a form to show the same record.

[Kushtrim]

Hi everyone,

I need some help on creating a macro that will open a form a show a specific record automatically.

I have a form that shows some fields of a record, on double click I need to open another form that shows every filed of that specific record.

I need this to be as simple as possible.


Thanks everyone.

 

[vbaInet]

You can use the WHERE argument of the OpenForm method. Follow the instructions in the following link and put it in the ON CLICK event of your button:

http://baldyweb.com/wherecondition.htm