Hey there, can anyone help with setting up a Recordset. I am trying to create a search page which searches an Access database. When setting up the Recordset I enter all the relevent information. Im told that I should test the record set because I have set some filters. When testing a new screen pops up and asks me to "Provide a test value for the Form Variable: Supplier Id. I dont understand what I should enter here. Where would i look to find what I should be entering here.

Thanks for any help in advance.

Mal R

if for example you have a customer database holding all customer names, when you filter the database on the customer name field the test value for the form variable would be an example of the customer name (one that would be found in your table).

So for your table filter on the supplier id (enter an example of that field in your table).

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]