Problem with a form data result

  • Thread starter Thread starter RayVac
  • Start date Start date
R

RayVac

I have a data base on MSAccess 2000 in which i have a table with a field
format numeric that represent the customer number.
When i search directly in my table for a specific customer number; all work
fine and i get the information. When i use a query attached to this table
and that have a criteria as ( [Type in customer number]; all work fine too i
get allways the information i need. But when i use my form; i never able to
obtain my information whenever i use the same request as data source. I
receive the message that no data correspond to my request.
 
Ray,
You wrote...
But when i use my form; i never able to obtain my information...
Click to expand...
It would have been helpful had you described how you're doing that on
your form...

Without any details, I can only suggest trying Val(YourSearchData).
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

RayVac said:
I have a data base on MSAccess 2000 in which i have a table with a field
format numeric that represent the customer number.
When i search directly in my table for a specific customer number; all
work
fine and i get the information. When i use a query attached to this table
and that have a criteria as ( [Type in customer number]; all work fine too
i
get allways the information i need. But when i use my form; i never able
to
obtain my information whenever i use the same request as data source. I
receive the message that no data correspond to my request.
Click to expand...
 
I'm not clear just how you want the form to operate, but I guess you want a
control on a bound form to take you to the selected record in the form's
underlying recordset. I'd suggest having an unbound combo box on the form
with a RowSource property such as:

SELECT CustomerNumber
FROM Customers
ORDER BY CustomerNumber;

In its AfterUpdate event procedure put:

Dim rst As Object

Set rst = Me.Recordset.Clone

rst.FindFirst "CuctomerNumber = " & cboFindCustomer
Me.Bookmark = rst.Bookmark

This assumes CustomerNumber is a number data type, not text. As this code
navigates to the first matching record, if the form is based on a table which
has multiple rows per customer, e.g. an Orders table, then you should sort
the form's data by customer number, so that the records per customer are
grouped together, by basing it on a query such as:

SELECT *
FROM Orders
ORDER By CustomerNumber, OrderDate;
 
Back
Top