|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
March 30th, 2005, 01:07 PM
|
|||
|
|||
Filter
I need to write a query that pulls a single record, then tie the form to the query. I would probably need a parameter in the query that specifies which record to pull, maybe the primary key value from the table (for example, Account_Num). Its for a database that has Access XP on the front end and SQL server 2000 as the engine
I am just not sure on how to do this, can anyone help??
|
|
#2
March 31st, 2005, 07:01 PM
|
|||
|
|||
|
Can't you set the recordsource to the form you are tying to open you query and then when you open your form set a filter?
This is straight from the MS Access help file DoCmd.OpenForm "Employees", , ,"LastName = 'King'" Hope this helps
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Filter |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
