|
Subject:
|
ms access form as criteria on sql server backend
|
|
Posted By:
|
ottos13
|
Post Date:
|
9/12/2006 6:40:04 PM
|
hi guys
i have an access form link to a sql server backend. i'm wanting to have a form textfield as a criteria on a stored procedure.
how do i do this?
i entered:
=[Forms]![frmNewJob]![Job_no]
and it did this which prompts for the field name
= @_Forms___frmNewJob___Job_no_
i also tried
=N'[Forms]![frmNewJob]![Job_no]' but that treats it as a string ("[Forms]![frmNewJob]![Job_no]") and not a form value
anyone done this?
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
9/13/2006 12:14:31 PM
|
Take the value as a variable, and pass the variable:
Dim iJob As Integer (It looks like an integer field)
iJob = Me.Job_No
Now pass iJob to the SP.
Are you using an event on the form to trigger the SP?
Does this help?
mmcdonal
|
