query filtering from form

[stevie1969]

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

 

[systematic]

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

 

[pyrohavoc]

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?