Inputbox value to be used as a filter on a query

[kaluapig]

Inputbox value to be stored to a particular table/row

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]

You can do it with VBA rather than with macros ... declare a variable and set it to the value of your inputbox.

 

[kaluapig]

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