View Full Version : Inputbox value to be used as a filter on a query


kaluapig
11-11-2004, 01:59 PM
Hello,

Could anyone guide me on how to get a macro to run an inputbox that would take a users input and edit a particular field of a certain record in a table? PHEW!

The other question is, how to get a query to use this particular value (from the table) to filter a certain field.

Thanks,

Nick

P.S. I'm used to doing that point and click thing in Access as I do not understand that SQL language. Please so go easy on me...thx :)

maxmangion
11-11-2004, 11:44 PM
You can do it with VBA rather than with macros ... declare a variable and set it to the value of your inputbox.

kaluapig
11-15-2004, 08:49 AM
Thanks for the reply!

Because I do not know VBA, could you tell me what to research or point me in the right direction so that I can perform this function?

Thanks