I am making a database (A Quote maker) and the basis of the database is that I have a pricelist in a table prices. The products are grouped in several categories, such as ram, cpu etc. The items all have a product ID as the key field. Then these go into a query where they are linked to quote ID in a query. I can make a form easily enough if i just make a datasheet view and use it as a subform and all the relationships with everything else work fine

However I really want my form to be made of a listing of each category. I can make a query by using the table so that for example it only looks for cpus. However as i then put another "product ID" onto this form it is related to the previous one i made. So basically how do i get this to work. I know i can use multiple queries, however i would prefer not to have to as this would be wasted space and really (i hope) arent nesecary

Thanks for any help

Chris

I think you should use the ME.refresh function, perhaps in an after update event. (after you´ve put in a new record.)

Search the forum for ME.refresh.

Fuga.