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?

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