On Sat, 13 Mar 2010 14:29:28 GMT, "sys_analyst47 via AccessMonster.com"
u58607@uwe wrote:

Well i fix it by the way ... tell me one thing is it possible that i have a
combo box i will put assume a customer ID in it and this will fetch product
sold from another table ...if so please let me know exactly how to do tht

Yes it is possible. However you will need to help me: I do not know the
structure of your tables, and I do not know where the product sold is to be
found.

Please post a description of your tables in the form

Customers
CustomerID
LastName
FirstName
...

OtherTable
Thisfield
Thatfield
...

and indicate how the tables are related.
--

John W. Vinson [MVP]