a2k - filtering a form 1

[Richard6699]

This is so basic but I need a bit of help...

I have a main form containing employees.

If the user clicks a button to open a popup form, this should only contain related records.

So I need to open this popup using the id of the current employee. This will then hopefully filter the popup form's underlying table so I only see the related records.

My docmd.openform code is simply not working or gives an error.

Anyone have some code for what seems a straightforward problem?

thanks

 

[theUN4GVEN]

Richard,

I do this a lot in the program I am working on now. I use openArgs to pass a value from my txtID field to the popup form.

DoCmd.OpenForm "frmPopup", OpenArgs:=Me.txtID.Value

Then in the popup forms onOpen I use

Me.txtID.Value = Me.OpenArgs

and then I set the Me.RecordSource = "Query using me.textID.value to filter"

There are probably easier ways to do this but this is the one I learned and it has always worked.

Tom