Hi thanks for your reply, its much appreciated.

The problem is I don't know how to populate the [ACC] variable. I can only put data into this variable when it pops up as an inputbox. I can't pass information to it from another query. Simply put I would like to be able to set the [ACC] variable in query2 to a value say 'RB123456', which would then be sent to query1, without the inputbox popping up.

The way the database...

Hi, this is literally driving me mad, to me it seems the simplest thing in the world to do but I have found absolutely no way of doing it.

Simply put I have a query which i'll call Query1 where it asks for input in the form:

[ACC]

I also have another query that uses Query1 for its information. How ON EARTH do I pass a variable to Query1 for [ACC]. It pops up with a textbox everytime but I don't want...