Need help with form, table, and cmd button

[GregSmith]

I have a command button that when pressed by 'user x' will open up a popup screen and display his entries from the table.

Atleast this is what I am trying to do. Any code ideas on how to do this? I do not want to use a query if I can get around it.

 

[Rakier]

Well, since you don't want to use a query, you could do it this way.

Create the pop-up form with a series of unbound text-boxes (as many as you need for the data).

Then on the pop-up form, use the DLookup Function to populate the textboxes.

Example:

DLookup ("tablefieldname","tablename","[tableuserID] = [forms]![form name that you open the pop up from]![userIDfield from that form]")

Of course this assumes that the user ID is located somewhere on the first form. If not, you will need to reference that user's id from somewhere else.

You would need a DLookup statement for each text box on the pop-up form.

HTH