query filtering from form

stevie1969

Registered User.
Local time
Today, 05:03
Joined
Mar 10, 2006
Messages
22
I have a query that when run asks for a client ID and then displays a total of funds for that client.

I also have a form for each client's persobal details and I would like to have a command button on that form, that when clicked runs the query automatically using the client ID being used.

I can get a command button to open another form based on client ID but not a query.

many thanks
 
Hi Stevie,

Assuming you have a control on your form that contains the client ID - eg a text box - pretty sure you can just put a criteria in the expression -

[ID] = Forms!MyForm!MyControl

Then when you click the command button, your query criteria will filter the results based on the user ID.

Regards,

Robert
 
systematic said:
Hi Stevie,

Assuming you have a control on your form that contains the client ID - eg a text box - pretty sure you can just put a criteria in the expression -

[ID] = Forms!MyForm!MyControl

Then when you click the command button, your query criteria will filter the results based on the user ID.

Regards,

Robert
sounds a hell of a lot like what i'm trying to do

http://www.access-programmers.co.uk/forums/showthread.php?t=107490

think you can give me a hand?
 

Users who are viewing this thread

Back
Top Bottom