Data2.RecordSource = "SELECT * FROM prices WHERE subkey = " & 

data1.recordset!ID

data2.refresh



why does the above code not work to fill a grid.



but the code below does work

data2.recordsource = "SELECT * FROM prices"

data2.refresh



in English my aim is to 

txtprice.text = costprice where primary supplier in table products = 

primary supplier in table prices

How are you using this code? Is this a subform recordsource? If it is then 

you can use the Parent/Child link by ID.

I don't understand what you mean by grid? When I look up the word grind in 

Access, it reference the grids (dots) to a form.



Would like to help,



>>> "chris angus" <chris@a...> 10/24 12:10 AM >>>

Data2.RecordSource = "SELECT * FROM prices WHERE subkey = " &

data1.recordset!ID

data2.refresh



why does the above code not work to fill a grid.



but the code below does work

data2.recordsource = "SELECT * FROM prices"

data2.refresh



in English my aim is to

txtprice.text = costprice where primary supplier in table products 

primary supplier in table prices

What is the data type of the ID?  If it's text, you'll need to delimit the

value in quotes...



HTH,



-Roy



Roy Pardee

Programmer/Analyst

SWFPAC Lockheed Martin IT

(xxx) xxx-xxxx



-----Original Message-----

From: chris angus [mailto:chris@a...]

Sent: Tuesday, October 23, 2001 5:11 PM

To: Access

Subject: [access] could someone give me a little help please





Data2.RecordSource = "SELECT * FROM prices WHERE subkey = " & 

data1.recordset!ID

data2.refresh



why does the above code not work to fill a grid.



but the code below does work

data2.recordsource = "SELECT * FROM prices"

data2.refresh



in English my aim is to 

txtprice.text = costprice where primary supplier in table products = 

primary supplier in table prices