querying values in a forms subform

[alastair_herron1975]

I'm having trouble creating a query using an msaccess adp with an sql backend.

I have a form with a subform, within the subform I have a button which runs a query, the query then should get the ID value from the sub form, I have tried everything, the closest I could come is:

SELECT ID, Name, IPAddress, Manufacturer, AssetTag, Type, SerialNumber, Dept, Model, Location, Processor, MemoryType, HardDrive, CDType, Owner, CurrentCondition, DateLastChecked, MAC
FROM dbo.Data
WHERE (ID = @Forms_Location__Location_Subform__ID)

according to microsoft this is the correct syntax, however when the query is run I get the following popup:

enter parameter value : Forms_Location__Location_Subform__ID

If I enter a valid ID value then the query returns the correct data, I'm presaumning the query doesn't know where to get the parameter value from.

Can anyone help please.

PS when creating queries in adp projects I can't select a form value, using their wizard, why is this?

[CaptainD]

Usually when I create a query I run it through a msgbox to see if my query to the database is as it should be.

Also, Where does "@Forms_Location__Location_Subform__ID" come from and have you checked the value it gives. ID fields are usually integers, is that what you are passing.

In your case, to see what you are trying to pass.

Dim strSql as string
strSql = "SELECT ID, Name, IPAddress, Manufacturer, AssetTag, Type, SerialNumber, Dept, Model, Location, Processor, MemoryType, HardDrive, CDType, Owner, CurrentCondition, DateLastChecked, MAC
FROM dbo.Data
WHERE (ID = @Forms_Location__Location_Subform__ID)"
 
MsgBox strSql
 

My guess is, you will not be passing an integer to the query and, the "@" symbol is used in MS SQL Server stored procedure for parameters, they're not usually (Or you can't, don't know) used for fields or variables in Access.

Put your SQL string in a message box and see what it looks like, you should see the problem.